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 MySQL
mysql -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.
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;
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.