当前位置：Gxlcms >
数据库问题 >
mysql创建用户并授权Repl_slave_priv和Repl_client_priv
mysql创建用户并授权Repl_slave_priv和Repl_client_priv
时间：2021-07-01 10:21:17
帮助过：118人阅读
CREATE USER ‘test‘@
‘localhost‘ IDENTIFIED
BY ‘test‘;
2
3 FLUSH
PRIVILEGES;
4
5
6 GRANT REPLICATION CLIENT
ON *.
* TO test
@localhost IDENTIFIED
BY ‘test‘;
7
8 GRANT REPLICATION SLAVE
ON *.
* TO test
@localhost IDENTIFIED
BY ‘test‘;
9
10 RESET SLAVE;
mysql创建用户并授权Repl_slave_priv和Repl_client_priv
标签：sql ide grant mysq cli 用户 mysql div slave
