How to connect to MySQL visualization tool Navicat

After installing Navicat

The following error may occur: Client does not support authentication protocol requested by server

At this time, enter mysql -u root -p in the mysql bin file directory and enter the password, enter the mysql terminal, and enter the command in the terminal:

alter user 'root'@'localhost' identified with mysql_native_password by ''

Add your MySQL password after the single quotes.

Then reconnect.

Registration code: NAVHWK6ADMVKDKW3

Modify the mysql usage permissions to anyone in the LAN.

mysql> use mysql;
mysql> update user set host = '%' where user = 'root';
mysql> select host, user from user;
mysql> flush privileges; 

Summarize

The above is the full content of this article. I hope that the content of this article will have certain reference learning value for your study or work. Thank you for your support of 123WORDPRESS.COM. If you want to learn more about this, please check out the following links