Error 2059 in new connection after installing Navicat
Open Doc window Win + D type CMD to open
The input
Mysql -u root -p
Enter the password for root
Select database
The input
use mysql
View the rules for encryption
The input
select Host,User,plugin from mysql.user;
Encryption mode is the new encryption mode
Change back to the original encryption mode
The input
ALTER USER ‘root’@’localhost’ IDENTIFIED WITH ‘mysql_native_password ‘;
The refresh
FLUSH PRIVIEGES;
Check the encryption again
select Host,User,plugin from mysql.user;
Now you can connect to the database
Open Doc window Win + D type CMD to open
The input
Mysql -u root -p
Enter the password for root
Select database
The input
use mysql
View the rules for encryption
The input
select Host,User,plugin from mysql.user;
Encryption mode is the new encryption mode
Change back to the original encryption mode
The input
ALTER USER ‘root’@’localhost’ IDENTIFIED WITH ‘mysql_native_password ‘;
The refresh
FLUSH PRIVIEGES;
Check the encryption again
select Host,User,plugin from mysql.user;
Now you can connect to the database