mysql8.0 用户授权

create user 'user-xxx'@'%' identified by 'passworddddd';
grant all privileges on *.* to 'user-xxx'@'%' with grant option;
ALTER USER 'user-xxx'@'localhost' IDENTIFIED WITH mysql_native_password BY '你的数据库密码';
flush privileges;

#收回权限(不包含赋权权限)
REVOKE ALL PRIVILEGES ON *.* FROM user_name;
REVOKE ALL PRIVILEGES ON user_name.* FROM user_name;
#收回赋权权限
REVOKE GRANT OPTION ON *.* FROM user_name;
flush privileges;


------------------------------------------------------------------------------------------------------------
Navicat连接mysql8.0
2059 - Authentication plugin 'caching_sha2_password' cannot be loaded:xxxx

#登录
mysql -uroot -ppassword
use mysql;

# 注意:如果是远程连接,请将'localhost'换成'%'
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '你的数据库密码';

FLUSH PRIVILEGES;

posted @   walkersss  阅读(70)  评论(0编辑  收藏  举报
相关博文:
阅读排行:
· 一个费力不讨好的项目,让我损失了近一半的绩效!
· 清华大学推出第四讲使用 DeepSeek + DeepResearch 让科研像聊天一样简单!
· 实操Deepseek接入个人知识库
· CSnakes vs Python.NET:高效嵌入与灵活互通的跨语言方案对比
· Plotly.NET 一个为 .NET 打造的强大开源交互式图表库
点击右上角即可分享
微信分享提示