MySqlErrorAll
连接失败
2059 - Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(../Frameworks/caching_sha2_password.so, 2): image not found
-
mysql -uroot -ppassword
#登录 -
use mysql;
#选择数据库 -
远程连接请将
'localhost'换成'%'
1 2 3
sqlALTER USER 'root'@'localhost' IDENTIFIED BY 'lichaocheng' PASSWORD EXPIRE NEVER; #更改加密方式 ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'lichaocheng'; #更新用户密码 FLUSH PRIVILEGES; #刷新权限
-
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';
This post is licensed under
CC BY 4.0
by the author.