1-MySQL8 - caching_sha2_password
about caching_sha2_password#
创建基于mysql_native_password的用户#
-- 创建新用户
create user zhangkai@'%' identified with mysql_native_password by '123';
flush privileges;
-- 如果是已有用户，改成 mysql_native_password
alter user zhangkai@'%' identified with mysql_native_password by "123";
flush privileges;
-- 或者使用下面的update命令修改
use mysql;
update user set plugin='mysql_native_password' where user='zhangkai';
flush privileges;
select host,user,plugin from mysql.user;
mysql> select host,user,plugin from mysql.user;
+-----------+------------------+-----------------------+
| host | user | plugin |
+-----------+------------------+-----------------------+
| % | zhangkai | mysql_native_password |
| localhost | mysql.infoschema | caching_sha2_password |
| localhost | mysql.session | caching_sha2_password |
| localhost | mysql.sys | caching_sha2_password |
| localhost | root | caching_sha2_password |
+-----------+------------------+-----------------------+
5 rows in set (0.00 sec)
参考:
【推荐】国内首个AI IDE，深度理解中文开发场景，立即下载体验Trae
【推荐】编程新体验，更懂你的AI，立即体验豆包MarsCode编程助手
【推荐】抖音旗下AI助手豆包，你的智能百科全书，全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell：AI 加持，快人一步