Navicat Premium 12 does not have a problem, but Navicat for MySQL does not have a problem, but Navicat for MySQL does not have a problem.

Problem reproduction

Navicat Premium 12 went well, one hit! Data can also be easily queried through MySQL statements!If you use Navicat for MySQL, the following error occurs.What to do?

The solution

There are many online practices that are adoptedcmdLog in to MySQL, but I thought it would be better to open the MySQL command window directly. It is said that the new mysql password algorithm is inconsistent with the Navicat client password algorithm. All we need to do is reset the password once ok.Well, it’s notnewpassowrdisnewpassword(Hand slips on the wrong word)

Ok, now the password reset is complete (you can re-log in yourself to test the new password)

Then reopen Navicat to connect to the databaseIntuitive query table contentQuery the table from the command line (F6)Query table by code (CTRL +Q) (with code completion)As an aside, Navicat Premium 12 is still better than Navicat for MySQL. For now, I only have Navicat Premium 12 for MySQL.

The attached code

//Mysql use mysql;//To reset your passwordalter user 'root'@localhost identified with mysql_native_password by 'new_password';
//Refresh privileges flush PRIVILEGES;Copy the code

The resources

[1] Navicat failed to connect to Mysql

[2] Legal database management tool Navicat for MySQL Chinese software installation, cracking steps