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 @ 2022-11-30 09:13  任国强  阅读(158)  评论(0)  编辑  收藏  举报