Shulou(Shulou.com)05/31 Report--

This article mainly explains the "SQLyog connection MySQL8.0 report 2058 error solution", the article explains the content is simple and clear, easy to learn and understand, now please follow the editor's train of thought slowly in depth, together to study and learn "SQLyog connection MySQL8.0 newspaper 2058 error solution"!

Reason

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

Type the password for the root account

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 Query OK indicating that the modification was successful.

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.

Thank you for your reading, the above is the content of "SQLyog connection MySQL8.0 report 2058 error solution". After the study of this article, I believe you have a deeper understanding of the problem of SQLyog connection MySQL8.0 report 2058 error solution, and the specific use situation still needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

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.