1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 |
# 创建用户 * mysql_native_password CREATE USER 'username'@'%' IDENTIFIED WITH mysql_native_password BY 'passwd'; * authentication_plugin CREATE USER 'username'@'host' IDENTIFIED WITH authentication_plugin BY 'password'; * 修改密码验证方式 ALTER USER 'username'@'host' IDENTIFIED WITH mysql_native_password BY 'password'; # 授权 GRANT ALL PRIVILEGES ON *.* TO 'username'@'%' WITH GRANT OPTION; GRANT CREATE, ALTER, DROP, INSERT, UPDATE, DELETE, SELECT, REFERENCES, RELOAD on *.* TO 'username'@'localhost' WITH GRANT OPTION; |
本着互联网开源、开放的精神和宗旨,本站所有内容可以随便传播。如需转载或分享无需说明来源。
有任何疑问或烦恼,欢迎评论区讨论。
755
暂无回复数据