Shulou(Shulou.com)06/01 Report--

Introduction

Using SQLyog to connect MySQL8.0 (community version: mysql-installer-community-8.0.15.0.msi), there is an error 2058 (Plugin caching_sha2_password could not be loaded:xxxx). The cause of the error is understood by querying the data and the scheme of the problem is put forward in this paper.

Reason

The error message is shown in the following figure:

Specific reason: the new MySQL 8.0 installation, when initializing the data directory, create an account with 'root'@'localhost', and the account caching_sha2_password is used by default, the encryption method of the password has changed, so SQLyog can not be parsed normally, so the above error is reported.

Solution

Run [start]-[all programs]-[MySQL]-[MySQL Server 8.0]-[MySQL 8.0 Command Line Client-Unicode] as an administrator, as shown below:

Type the password for the root account as shown below.

Enter the command in the following sql format, where password is the password of the root account.

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY' password'

Execute the command, and the result is that the Query OK indicates that the modification was successful, as shown in the following figure.

Reconnect the MySQL with SQLyog and you can connect successfully. At this point, look at the user table in the mysql database and find that the plug-in name of the root account has changed, as shown below.

Summary

The new version of MySQL has its advantages (some new features) and some disadvantages (some operation and maintenance tools can not meet the needs of the new version). We should consider carefully before we choose to avoid some unpredictable problems. Only by discovering problems, solving problems and summing up solutions, can you constantly improve yourself. If this article can help you understand or solve the problem, I hope to add attention!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.