[MySQL moe new Installation FAQ]

1. Installation

According to this process: http://jingyan.baidu.com/article/cd4c2979033a17756f6e6047.html

FAQ: installation stays on a step cannot continue.

Workaround:

1. installation file storage path cannot contain Chinese (note that the path to the installation file is not the installation path)

2. The last installation of MySQL was not uninstalled, removed cleanly. Detailed reference address: http://blog.csdn.net/m0_37373806/article/details/55049853

2. Turn on remote links

Because MySQL does not have a good graphical interface, the first use of people even Baidu is difficult to know how to open remote connection.

First find the installed MySQL folder in the Start menu Open Mysql5.7 command line clinent (for input commands, note not to open the Windows command Prompt)

1. Open and enter the password set at the time of installation. Enter

2. Enter use MySQL; (function for entering the database.) Attention must be scored number)

3. Enter update user set host = '% ' where user = ' root '; (function to modify the root account scope in the MySQL table, originally localhost, now%.) means remote, that is, any address

4. Enter select Host, user from user, (function for query modification, corresponding to a bit of database experience can understand)

5. Enter the FLUSH privileges; (It is important for the change to take effect)

6. Enter exit; (function for exit)

All right. Hope to help you, above I spent a lot of time to solve, although the problem is not big. But I really feel that MySQL is not friendly to beginners in the big pits.

[MySQL moe new Installation FAQ]