Connection Method of MySQL Visualization Tool Navicat

Time:2019-6-15

After installing Navicat

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

At this point, type in the bin file directory of MySQLmysql -u root -p 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 ''

After the single quotation mark, add your own MySQL password.

Then reconnect.

Registration code: NAVHWK6ADMVKDKW3

Modify MySQL permission 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;

summary

Above is the whole content of this article. I hope the content of this article has some reference value for your study or work. Thank you for your support to developpaer. If you want to know more about it, please check the links below.

Recommended Today

Api: tiktok: user video list

Tiktok tiktok, tiktok, tiktok, Api, Api, jitter, voice, bullet screen comments, jitter, jitter, and jitter. Tiktok tiktok tiktok data, jitter data acquisition, live broadcast of shaking sound Titodata: professional short video data acquisition and processing platform. For more information, please contact:TiToData Massive data collection Collect 500 million pieces of data for customers every day Tiktok […]