How to Manually Install MySQL on Windows

MySQL is one of the world’s most widely used open-source relational database management system. It is a popular choice of database for use in web applications and is the M in WAMP stacks. WAMP stands for Windows, Apache, MySQL, PHP. This tutorial is on how to manually install MySQL on Windows 7.

Installation

1. Go to dev.mysql.com/downloads/.
2. Choose MySQL Community Server for Windows.
3. Download the Windows (x86, 32-bit), ZIP Archive.
4. Once the download has completed, extract the contents of the ZIP and rename the folder “mysql-5.6.19-win32″ to “mysql”.
5. Move the “mysql” folder to D:\webserver\.
   

Configure MySQL

6. Inside D:\webserver\mysql find and rename the file my-default.ini to my.ini. This is the MySQL configuration file.
7. Open my.ini and find:

   [mysqld]

8. Under it find:

   # basedir = .....
   # datadir = .....

9. And replace with:

   # points to installation directory
   basedir="D:/webserver/mysql/"
   # points data directory
   datadir="D:/webserver/mysql/data/"

   

10. Save my.ini.

Install MySQL as Windows Service

11. Open cmd and run it as administrator and go to drive D by typing:

    D:

    Hit enter to run the command.

12. Go to the MySQL bin folder by typing the command below and hitting enter:

    cd webserver/mysql/bin

13. Test mysql if it will run by typing the command below and hitting enter:

    mysqld

14. To shutdown mysql, open another command prompt and type this command:

    mysqladmin.exe -u root shutdown

15. Now that mysql can run, install it as a windows service by typing this command:

    mysqld --install

MySQL should now be installed and will run everytime Window starts.

Uninstall MySQL Windows Service

1. Stop the running service either via the service console or via task manager in windows 8.
2. Open cmd and run it as administrator and go to drive D by entering:

   D:

3. Go to the MySQL bin folder by typing the command below and hitting enter:

   cd webserver/mysql/bin

4. Delete it by typing the command below and hitting enter:

   sc delete MySQL

   where “MySQL” is the name of the service.