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
Read More:
- Navicat premium essentials for Mac database settings
- Error in activation of Navicat premium register
- Navicate premium Connecting to a remote Oracle,ORA-12514: TNS:listener does not currently know of service requested in c
- Using Navicat + premium + 11.1 to connect to PG12 version, error: column c.relhasoids does not exist
- Navicat VMware failed to connect to the database. Possible causes of error 2003
- Pikachu vulnerability is installed in the shooting range, and an error is reported when connecting to the MySQL database
- A series of errors encountered in connecting to the database using Oracle SQL developer
- Solve the error of ora-12514 when Navicat connects to Oracle Database
- The solution to the problem that the method of interacting with database in the servlet class is invalid after the servlet submits 404, 500 refresh and becomes 404, and after connecting to the data pool
- Navicat import local SQL file error “[MSG] finished – unsuccessfully | [err] 1046 – no database selected”
- The problem of [connection lost contact] after C # code connecting Oracle database for a period of time
- Navicat for MySQL error 1251 failed to connect to MySQL
- Error when connecting to database: DB2 SQL error: sqlcode = – 204, sqlstate = 42704, sqlerrmc= YXUAT.CUST_ BLK_ REL, DRIVER=4.25.13
- Appium connecting to the ADB 5037 port of nocturnal simulator is occupied by itself
- Connect to the repository by using the database resource library!
- Oracle can’t start the database due to deleting DBF file by mistake
- Encapsulation of adding, deleting and modifying database by JDBC
- [Solved] org.mongodb.driver.cluster – Exception in monitor thread while connecting to server node1:27017
- 530 user cannot log in. Problem connecting to FTP server
- Error connecting to master, – retry time: 60 retries: 86400