Shulou(Shulou.com)05/31 Report--

This article mainly introduces the navicat connection MySQL8.0.11 report 2059 error how to do, the article is very detailed, has a certain reference value, interested friends must read it!

New features are enabled in the MySQL8.0.11 version, and the user login encryption rules have been changed to caching_sha2_password. If you want to use the new features of caching_sha2_password, you must update the navict driver. Otherwise, a 2059 error will be reported when connecting with navicat. If you want to continue to use the old features, you can restore the encryption rules of mysql login to mysql_native_password.

The methods are as follows:

1. Modify / etc/my.cnf

Join default_authentication_plugin=mysql_native_password

Note: restart takes effect

two。 Use the command line:

Mysql > ALTER USER 'test'@'%' IDENTIFIED BY' 123456' PASSWORD EXPIRE NEVER

Query OK, 0 rows affected (0.13 sec)

Mysql > ALTER USER 'test'@'%' IDENTIFIED WITH mysql_native_password BY' 123456'

Query OK, 0 rows affected (0.21 sec)

The above is all the contents of the article "how to report 2059 errors in navicat connection MySQL8.0.11". Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.