Installing MySQL (Under Windows) - Page 3
January 3, 2002
As I mentioned above, MySQL may be downloaded free of charge. Simply proceed to http://www.mysql.com/downloads/ and choose the recommended stable release (as of this writing, it is MySQL 3.23). Under the heading of Standard binary (tarball) distributions (which basically means the program doesn't need to be compiled, and is ready to run once you download it), find and click Windows 95/98/NT/2000 (Intel). If you're on a high-speed connection, you'll probably want to check out one of the download mirrors listed at http://www.mysql.com/downloads/mirrors.html to get a reasonable download speed. After downloading the file (it's about 12MB as of this writing), unzip it and run the setup.exe program contained therein.
Once installed, MySQL is ready to roll (barring a couple of
configuration tasks that we'll look at shortly), except for one
minor issue that only affects you if you're running Windows
NT/2000/XP. If you use any of those operating systems, find a
Uncomment this line by removing the '
With that change made, save the file and close WordPad. MySQL will now run on your Windows NT/2000/XP system! If you're using Windows 95/98/ME, this step is not necessary -- MySQL will run just fine as-installed.
Just like your Web server, MySQL is a program that should be run in the background so that it may respond to requests for information at any time. The server program may be found in the "bin" subfolder of the folder into which you installed MySQL. To make things complicated, however, there are actually several versions of the MySQL server to choose from:
All these versions were installed for you in the
Starting MySQL is also a little different under WinNT/2000/XP,
but this time let's start with the procedure for Win95/98/ME.
Open an MS-DOS Command Prompt and proceed to the MySQL
Don't be surprised when you receive another command prompt. This command launches the server program so that it runs in the background, even after you close the command prompt. If you press Ctrl-Alt-Del to pull up the task list, you should see the MySQL server listed as one of the tasks that's active on your system.
To ensure that the server is started whenever Windows starts, you might want to create a shortcut to the program and put it in your Startup folder. This is just like creating a shortcut to any other program on your system.
On WinNT/2000/XP, you must install MySQL as a system service.
Fortunately, this is very easy to do. Simply open a Command
Prompt and run your chosen server program with the
This will install MySQL as a service that will be started the next time you reboot Windows. To manually start MySQL without having to reboot, just type this command (which can be run from any directory):
To verify that the MySQL server is running properly, press Ctrl- Alt-Del and open the Task List. If all is well, the server program should be listed on the Processes tab.