The cause of the problem

    stay navicat link mysql8 The reason that later versions appear is in mysql8 In previous versions, the encryption rule was mysql_native_password,

And in the mysql8 The later encryption rules are caching_sha2_password.

There are two ways to solve this problem ,

One is updating navicat Drive to solve this problem ,

One is to mysql The encryption rule for user login is modified to mysql_native_password. This article uses the second way .
 

Solution

ALTER USER ‘root’@’%’ IDENTIFIED BY ‘112233’ PASSWORD EXPIRE NEVER;

ALTER USER ‘root’@’%’ IDENTIFIED WITH mysql_native_password BY ‘112233’;

 FLUSH PRIVILEGES;

‘root’ Self defined user name ,

‘%’ It means that the user is open to IP,

It can be ‘localhost'( Local access only , amount to 127.0.0.1), It can be specific ‘*.*.*.*'( Specific IP), It can also be ‘%'( all IP You can visit ).

‘password’ It’s the authentication password you want to use .

yes ‘%'( all IP You can visit )`