Home  >  Article  >  Database  >  navicat installation error 2059

navicat installation error 2059

angryTom
angryTomOriginal
2019-08-07 11:32:553250browse

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

navicat installation error 2059

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

navicat installation error 2059

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

navicat installation error 2059

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.

navicat installation error 2059

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

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn