installation of MySQL

MySQL Download URL: http://dev.mysql.com/downloads/, binary or zip compression package can be, select the time to pay attention to the MySQL operating system environment and configuration requirements.

1) I downloaded is: mysql_5.6.24_winx64.zip, directly extracted to the directory you want to put.

2) My.ini Originally is My-default.ini, I change, can not need to get rid of the configuration file name. Open the My-default.ini and modify the contents. I only changed a few:

Note: The default port of MySQL is 3306, do not arbitrarily change the port number, otherwise the following error will occur.

3) Modify the environment variables on the computer, the path of the bin directory under the MySQL installation path is added to the system variable path, so that in the cmd window, the computer can find the tool in the bin directory according to the value of path, convenient to use. My Computer--Properties--Advanced system settings--"Environment variables" inside the tab "advanced".

4) Open the CMD command-line window with the privileges of the system administrator , run MySQL--install (provided the third step is performed, otherwise go to the bin directory of the installation path).

5) "Win+r", Run "Regedit.exe", open Registry manager. Hkey_local_machine--system--controlset001--services--mysql., click the ImagePath in the right window to modify the following:

H:\Andriod\MySql\mysql-5.6.24-winx64\bin\mysqld--defaults-file= "H:\Andriod\MySql\ mysql-5.6.24-winx64\my.ini"MySQL

Note: The blue file above is filled out according to your own situation, if the file name is not modified, fill in the original file name. The red part is the path of your own installation.

6) "Win+r", run services.msc, locate the service below to start.

7) Open cmd, enter command: Mysql-u root-p, initial installation default password, direct enter.

8) graphical manager available for download: Mysql-gui-tools.zip

installation of MySQL