When using navicat to connect to MySQL8, a 2059 error will occur. This is because the new version of MySQL uses the caching_sha2_password authentication method, but navicat does not yet support this authentication method. Below we will introduce you to the specific solutions.
Recommended tutorial:MySQL introductory video tutorial
## The solution is to change the verification method to the previous version (5.7 and The following) uses the authentication method mysql_native_password. For specific verification methods, you can view the user table plugin field in the default database 'mysql'. There will be no 2059 error when logging into the database from the command line. Log in to the database from the command line and execute the following command.ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';'root' can be changed to your own defined user name, 'localhost' refers to the IP open to the user, which can be 'localhost' (local access only, equivalent to 127.0.0.1), It can be specific '*.*.*.*' (a specific IP), or it can be '%' (all IPs can be accessed). 'password' is the authentication password you want to use.
Extended information
Navicat is a set of fast, reliable and affordable database management tools designed to simplify database management. And designed to reduce system management costs.It is designed to meet the needs of database administrators, developers and small and medium-sized enterprises. Navicat is built with an intuitive graphical user interface that allows you to create, organize, access and share information in a secure and easy way.
Navicat is world-famous and widely trusted by major enterprises, government agencies, and educational institutions around the world. It is also an essential daily working partner for practitioners from all walks of life. Since 2001, Navicat has been downloaded over 2,000,000 times worldwide and has a customer base of over 70,000 users. More than 100 Fortune 500 companies are using Navicat. Navicat provides up to 7 languages for customers to choose from and is recognized as the most popular database front-end user interface tool in the world. It can be used to manage and develop local or remote MySQL, SQL Server, SQLite, Oracle and PostgreSQL databases. Navicat is powerful enough to meet all the needs of professional developers, and is easy to learn for those new to database servers. With an extremely complete graphical user interface (GUI), Navicat lets you create, organize, access and share information in a secure and simple way. Navicat is available on three platforms - Microsoft Windows, Mac OS X and Linux. It allows users to connect to any local or remote server, and provides some practical database tools such as data model, data transfer, data synchronization, structure synchronization, import, export, backup, restore, report creation tools and plans to assist in managing data.The above is the detailed content of Navicat reported error 2059. For more information, please follow other related articles on the PHP Chinese website!