mysql创建用户并授权Repl_slave_priv和Repl_client_priv
标签：sql ide grant mysq cli 用户 mysql div slave
mysql创建用户并授权Repl_slave_priv和Repl_client_priv
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;