navicat installation error 2059

Sometimes error 2059 is reported when installing navicat. The reason for this error is that the password plug-in of MySQL 8 has been changed (caching_sha2_password), and navicat still uses the old version (mysql_native_password) when linking. The new version of the password plug-in cannot be found, so you can change the password plug-in to the original version to solve this problem. Simeon will introduce the solution to you.

Recommended tutorial: MySQL database introductory video tutorial

##1. Open the command line that comes with MySQL

2. After entering the password set when installing MySQL, enter the command line use mysql

3., select user,host ,plugin,authentication_string from user; View user, password plug-in and other information.

4. alter user 'username'@'ip_address' identified with mysql_native_password by 'password'; use this statement to change, for example, my 'root'@'localhost' replacement Remove 'username'@'ip_address' and replace 'password' with the new password example '123456'.

Note that the new password cannot be the same as the previous password, otherwise the setting will not be successful.

You can check and verify through the previous sentence.

The above is the detailed content of navicat installation error 2059. For more information, please follow other related articles on the PHP Chinese website!