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

How to solve the Authentication plugin error in MySQL database connection? In response to this problem, the editor summed up this article today. The steps to solve the problem are as follows:

1. Log in to mysql

two。 Modify account password encryption rules and update user password

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

3. Refresh permissions

FLUSH PRIVILEGES; # Refresh permissions

Run it again and you will find that there is no such error.

The above description is to solve the details of Authentication plugin in MySQL database connection, and the specific usage needs to be used by everyone through hands-on experiments. If you want to know more about it, welcome to follow the industry information channel!

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.