===================Mysql5.7================================== 如果还不行就再试试网上的另一个方法: 1.关闭mysql # service mysqld stop 2.屏蔽权限 #
./mysqld_safe --user=mysql --skip-grant-tables --skip-networking
屏幕出现: Starting demo from ..... 3.新开起一个终端输入 # mysql -u root mysql
mysql> use mysql;
mysql> update user set authentication_string=password('root') where user ='root'; mysql> FLUSH PRIVILEGES;//记得要这句话,否则如果关闭先前的终端,又会出现原来的错误 mysql> quit;
=================mysql8.0.11================
问题描述
连接时报错:
在navicat中报错client does not support authentication
在mysql workbench中报外部组件错误
解决步骤
使用如下命令:
mysql> alter user ‘root’@‘localhost’ identified with mysql_native_password by ‘123456’;
Query OK, 0 rows affected (0.60 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.18 sec)
成功。