Mac 电脑 mysql本地无法连接问题 提示 plugin was = caching_sha2_password

MAC电脑安装好mysql后发现用软件一直无法连接mysql数据库,连接的时候报错如下:

Client does not support authentication protocol requested by 

server. Consider upgrading MariaDB client. plugin was = 

caching_sha2_password 




##查看解决问题如下:

/usr/local/mysql/bin/mysql -u root -p


##登录到mysql后台后输入:

mysql>  use mysql;

mysql>  select user,host,plugin from user;


+------------------+-----------+-----------------------+
| user             | host      | plugin                |
+------------------+-----------+-----------------------+
| mysql.infoschema | localhost | mysql_native_password |
| mysql.session    | localhost | mysql_native_password |
| mysql.sys        | localhost | mysql_native_password |
| root             | localhost | caching_sha2_password |


+------------------+-----------+-----------------------+




mysql>  ALTER USER 'root'@'localhost' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER;
Query OK, 0 rows affected (0.06 sec)


mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';
Query OK, 0 rows affected (0.03 sec)


mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)


mysql> alter user 'root'@'localhost' identified by '123qwe';


Query OK, 0 rows affected (0.05 sec)







完成之后用root,123qwe即可登录