Navicat connects to MySQL8.0.11 and an error 2059 occurs

mistake

The following error occurs when connecting to MySQL using Navicat Premium:

reason

The encryption rule in versions before mysql8 is mysql_native_password, and after mysql8, the encryption rule is caching_sha2_password

solve

To change encryption rules:

mysql -uroot -ppassword #Login use mysql; #Select database # For remote connection, please replace 'localhost' with '%'

ALTER USER 'root'@'localhost' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER; #Change encryption methodALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password'; #Update user passwordFLUSH PRIVILEGES; #Refresh permissions 

Enter password

This is the end of this article about Navicat connecting to MySQL8.0.11 with error 2059. For more information about Navicat connecting to MySQL, please search 123WORDPRESS.COM's previous articles or continue to browse the following related articles. I hope you will support 123WORDPRESS.COM in the future!