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

This article mainly explains "how to solve the 1251 error when sqlyog connects to Mysql". Interested friends may wish to have a look. The method introduced in this paper is simple, fast and practical. Let's let the editor take you to learn how to solve the 1251 error when sqlyog connects to Mysql.

SQLyog is a professional graphics management software, SQLyog operation is simple, powerful, can help users easily manage their own MYSQL database, SQLyog supports a variety of data formats export, can quickly help users back up and restore data, but also quickly run SQL script files for users to provide convenience.

1251 client does not support authentication protocol requested by server;consider upgrading Mysql clientERROR 1396 (HY000): Operation ALTER USER failed for 'root'@'localhost'

The cause of the problem:

It is mainly due to the difference between the encryption rules before mysql8 and those after mysql8.

Solution:

1. First of all, mysql must be installed, and you can enter it in the mysql file in the cmd opened as an administrator (if you have configured the environment variable):

Whether the net start mysql service is enabled successfully

After the service starts successfully, enter the command: mysql-u root-p (no password for the first login, press enter directly)!

Then type after mysql >:

ALTER USER 'root'@'localhost' IDENTIFIED BY' password' PASSWORD EXPIRE NEVER; # modify encryption rules ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY' password'; # update the user's password FLUSH PRIVILEGES; # refresh permissions

After success, enter the modified password in sqlyog (the one I set here is 123456) to log in

At this point, I believe that everyone has a deeper understanding of "how to solve the 1251 error when sqlyog connects to Mysql". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

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.