MYSQL GRANT ALL PRIVILEGES

`
mysql --host=10.136.41.221 --port=3400 --user=my_public_rw--password=mypassword
mysql --host=10.136.41.221 --port=3400 --user=root --password=mypassword

GRANT ALL PRIVILEGES ON . TO 'my_public_rw'@'47.102.%' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;
FLUSH PRIVILEGES;

GRANT ALL PRIVILEGES ON . TO 'root'@'100.104.%' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON . TO 'root'@'100.104.236.%' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON . TO 'root'@'100.104.236.187' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON . TO 'root'@'100.104.236.171' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;

GRANT ALL PRIVILEGES ON . TO 'my_public_rw'@'100.104.%' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;
`

posted @   任国强  阅读(163)  评论(0编辑  收藏  举报
相关博文:
阅读排行:
· 阿里最新开源QwQ-32B,效果媲美deepseek-r1满血版,部署成本又又又降低了!
· Manus重磅发布:全球首款通用AI代理技术深度解析与实战指南
· 开源Multi-agent AI智能体框架aevatar.ai,欢迎大家贡献代码
· 被坑几百块钱后,我竟然真的恢复了删除的微信聊天记录!
· AI技术革命,工作效率10个最佳AI工具
历史上的今天:
2021-11-30 Java8 Stream Function
2018-11-30 正则表达式
点击右上角即可分享
微信分享提示