1. Error reporting
2. Reasons for error reporting
Because the encryption method of MySQL 8.0 is different from that of MySQL 5.0, an error will be reported when connecting
3. Solutions
You need to change the encryption method to connect successfully (follow the steps below).
1. Enter the DOS command and execute the following code to enter the database
mysql -uroot -proot //-u(database account) -p(database password)
2. Execute the following command
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password set during mysql installation';
You can also change the password with this command: change the password in the command to the new one
After completing the above two steps, there will be no error when connecting again.