Problems and solutions when installing MySQL8.0.13 on Win10 system

Operating system: Window10

MySQL version: 8.0.13-winx64

The installation steps are relatively simple, so I won't go into detail in this article. Here are the installation instructions provided by runoob:

http://www.runoob.com/mysql/mysql-install.html

Problems encountered after installation:

1: Access denied for user 'root'@'localhost' (using password: YES)

Solution:

1. Enter the cmd command window as an administrator and cd to the bin directory of the MySQL installation path.

2. Shut down the MySQL service:

net stop mysql

3. Use --skip-grant-tables configuration item to skip permission verification and enter MySQL.

Note: MySQL 8.x does not seem to support directly modifying the contents of the my.ini configuration file, which will result in "MySQL service cannot be started and the service did not report any errors."

Order:

mysqld --console --shared-memory --skip-grant-tables

Note: If --shared-memory is missing, an error message will be displayed: "TCP/IP, --shared-memory, or -name-pipe should be configured on NT OS".

4. Keep the window in step 3 open, then open the cmd window as an administrator and jump to the bin directory under the MySQL installation path, enter mysql, and you can enter successfully.

5. Refresh permissions:

FLUSH PRIVILEGES;

6. Change password:

ALTER USER 'root'@'localhost' IDENTIFIED BY '新密碼';

7. After the modification is successful, start the MySQL service normally and log in with the username and password to verify whether the settings are successful.

Start the MySQL service:

net start mysql

Login command:

mysql -uroot -p密碼


2. When using Navicat to connect to MySQL, an error message appears: Client does not support authentication protocol requested by server; consider upgrading MySQL client

Solution:

ALERT USER 'root'@'localhost' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER;
 ALERT USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';
 FLUSH PRIVILEGES;

Note: The default authentication plug-in for MySQL 8.x is Caching_sha2_password. The original plug-in used was mysql_native_password, which caused the original navicat and other connections to fail authentication.

Summarize

The above is the problems and solutions encountered when installing MySQL8.0.13 on Win10 system introduced by the editor. I hope it will be helpful to everyone. If you have any questions, please leave me a message and the editor will reply to you in time!