How to install MySQL In Windows

The MySQL distribution for Windows comes as a zip file and will need to be uncompressed before it can be used. Use WinZip or another tool of your choice to perform the decompression. Once you do, follow these instructions to install the server on a NT/2000/XP box:

1. Log on as the administrator user.

2. Stop the current MySQL if you’re performing an upgrade.

• Open a command prompt.


• If MySQL is running as a service, type net stop <mysql> where <mysql> is the name of the MySQL server service name (normally the value is mysql).


• If MySQL is running as an application, change to the /bin directory of the MySQL installation and type mysqladmin –u root shutdown.

3. If you are changing from the basic MySQL server to the Max version, you need to remove the service.

4. Locate the setup.exe file of the new installation from the uncompressed files.

5. After MySQL is installed, copy one of the configuration files in the installation directory to the root directory, c:/. If you are using the Max version of MySQL, configure the appropriate InnoDB or BDB options in the configuration file.

6. If you want to install the server as a service, type the command -mysqld-max-nt- --install (or --install-manual if you don’t want Windows to automatically start the service when the machine boots). If you are installing MySQL on Windows 95, 98, or ME, the server cannot be used as a service and thus you will need to start and stop the server manually. Use the mysqladmin.exe application in the /bin directory to start MySQL.