MySQL Installation and use

Installation tutorial for MySQL

Reference from rookie tutorial http://www.runoob.com/mysql/mysql-tutorial.html

Problem: No response to directory switching in cmd

On the cmd command line, use CD D:\ to not switch smoothly

Solution: Use cd/d d:\

It should be because I updated the minor differences caused by the new version of Win10.

Problem: Registration failed, error message can not find the Msvcp140.dll file?

Solution: Install vc++2015,

Solution from: 78980295;

Problem: The MySQL service on the local computer stops after it starts. Are some services automatically stopped when they are not being used by other services or programs?

Solution: Mysqld--initialize-insecure--user=mysql;

Note, to ensure that the data path is configured at the beginning, there is a data folder, and this folder must be empty;

Solution from: https://jingyan.baidu.com/article/0f5fb0991636376d8234ea7a.html

Problem: Using Navicat to log on to local server times wrong

Solution from: Questions about mysql8.0 configuration Navicat-Little rookie also want to fly article-know https://zhuanlan.zhihu.com/p/36087723

Successfully installed mysql8.0 server side, connection Navicat will prompt an error:

1251 Client does not the authentication protocol requested by server; Consider upgrading MySQL client

There are a number of similar errors that can be found online for 1251.

But basically all is suitable for MySQL 5.XX version, cannot run

Set password for root@localhost = old_password (' password ');

Or

UPDATE mysql.user SET Password = old_password (' password ') WHERE Host = ' localhost ' and user = ' root ';

Not even.

The correct solution here is:

(UPDATE mysql.user SET plugin = ' Mysql_native_password ';) at that time the SQL also ran and did not know if there was any use. You can experiment with the success of the SQL below alone

Alter user ' username ' @localhost identified with Mysql_native_password by ' your password ';

In the bar to find the essence of the reason:

Authentication method During the installation process, based on different encryption methods, so if you choose the first strong encryption, you will appear I described earlier phenomena;

The reload I chose the second authentication method, that is, to keep the old encryption method, this time can be connected directly.

At this point, you can use Navicat to operate the MySQL database normally.

MySQL Installation and use