< Pro Test > connect MySQL with navicat 8.0 error 2059

ERROR 2059 (HY000): Authentication plugin ' Caching_sha2_password ' cannot be loadedMay 07, 2018 15:56:32 read: 2997 more Personal Category: DockermysqlCopyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced. 80226934

Problem:

Connection to Docker-initiated MySQL appears: Error 2059 (HY000): Authentication Plugin
' Caching_sha2_password ' cannot be loaded

C:\mysqldata>mysql-h 127.0.0.1-p 13306-uroot-p Enter Password:
** ERROR 2059 (HY000): Authentication plugin ' Caching_sha2_password ' cannot be loaded:õò²»µ½ö¸¶¨µä䣿顣

Solution:

1. Enter the MySQL container

exec -it mysql2 /bin/bash

• 1

2. Go to MySQL

-uroot -pmima

• 1

3. Change the password

ALTER USER ‘root‘@‘%‘ IDENTIFIED WITH mysql_native_password BY ‘root‘;

• 1

The MySQL version may be too new to be created.

Resources:

1, ERROR 2059 (HY000): Authentication plugin ' Caching_sha2_password ' cannot be loaded
Https://www.cnblogs.com/chuancheng/p/8964385.html

2, 2059-authentication plugin ' caching_sha2_password '-navicat connection exception problem resolution
80061991

< Pro Test > connect MySQL with navicat 8.0 error 2059