Shulou(Shulou.com)05/31 Report--

This article mainly introduces the visualization tool Navicat how to connect MySQL, has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, the following let Xiaobian take you to understand.

After installing Navicat

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

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

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

Add your own mysql password after the single quotation marks.

Then reconnect.

Registration code: NAVHWK6ADMVKDKW3

Change the permission of mysql to anyone in the local area network.

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

Thank you for reading this article carefully. I hope the article "how to connect Navicat to MySQL" shared by the editor will be helpful to everyone. At the same time, I also hope you will support us and pay attention to the industry information channel. More related knowledge is waiting for you to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.