MySQL Installation FAQs

MySQL installation is divided into two versions, one is MSC, and the other is a zip.

Here's a look at the MSC version.

Some MSC after installation is not transferred to the Service configuration page, the personal think is the problem of the installation program, and your computer configuration and operation has no relationship.

MSC's installation tutorials are available on the web and are not introduced here.

Tell the main question.

1, in let you enter the root password that step, the password box below a checkbox, check the instructions can let others connect your MySQL service remotely, do not check the remote connection.

2, configure the last page, there are 4 steps need to start, but the last 1 steps often error.

Does not insert the picture, the last upload is OK.

Troubleshooting MySQL database installation to the last step when you apply security settings error NR. 1045 Incorrect Method:

Http://www.htmer.com/article/930.htm

Finally, use NAVICAT Premium remote login times 1130-host ' xxx.xxx.xxx.xxx ' is not allowed to connect to this MySQL server error.

The solution is as follows:

Http://jingyan.baidu.com/article/b907e627b0e3b846e7891cc9.html

But the above plan, the palliative does not cure. only for individual IPs.

Looked for a bit on the internet, and found a solution:

Http://www.jb51.net/softjc/63583.html

It would be nice to change the host value of the root in the user table to '% '.

The writing is a bit messy, make a look at it.

MySQL Installation FAQs