Home >> FAQs/Tutorials >> MySQL Tutorials >> Index

MySQL FAQs - Downloading and Installing MySQL on Windows

By: FYIcenter.com

Part:   1  2   3 

(Continued from previous part...)

How To Install MySQL?

MySQL is an open source database management system developed by MySQL AB, http://www.mysql.com. You can download a copy and install it on your local computer very easily. Here is how you can do this:

  • Go to http://dev.mysql.com/downloads/mysql/5.0.html.
  • Select the "Windows" and "Without installer" version.
  • Find a mirror site and download "mysql-noinstall-5.0.24-win32.zip".
  • Unzip the file, you will get a new sub-directory, ".\mysql-5.0.24-win32".
  • Move and rename this sub-directory to \mysql.
  • The installation is done and your MySQL server is ready.

How To Start MySQL Server?

If you want to start the MySQL server, you can run the "mysqld" program in a command window as shown in the following tutorial:

>cd \mysql\bin
>mysqld

"mysqld" will run quietly without printing any message in you command window. So you will see nothing after entering the "mysqld" command. You should trust "mysqld" and believe that MySQL server is running ok on your local computer now.

Another way to start the MySQL server is double-click \mysql\bin\mysqld.exe on your file explorer window.

How Do You Know If Your MySQL Server Is Alive?

If you want to know whether your MySQL server is alive, you can use the "mysqladmin" program in a command window as shown in the following tutorial:

>cd \mysql\bin
>mysqladmin -u root ping
mysqld is alive

The "mysqld is alive" message tells you that your MySQL server is running ok. If your MySQL server is not running, you will get a "connect ... failed" message.

How Do You Know the Version of Your MySQL Server?

If you want to know the version number of your MySQL server, you can use the "mysqladmin" program in a command window as shown in the following tutorial:

>cd \mysql\bin
>mysqladmin -u root version
mysqladmin  Ver 8.41 Distrib 5.0.24, for Win32 on ia32
Copyright (C) 2000 MySQL AB & MySQL Finland AB
 & TCX DataKonsult AB
...
Server version          5.0.24-community
Protocol version        10
Connection              localhost via TCP/IP
TCP port                3306
Uptime:                 25 min 9 sec

Threads: 1  Questions: 2  Slow queries: 0  Opens: 12 
Flush tables: 1  Open tables: 6 
Queries per second avg: 0.001

The output in the above example tells you that the version number is 5.0.24.

(Continued on next part...)

Part:   1  2   3 


Selected Developer Jobs:

More...