GRANT

Question

我是本地开启了两上mysql服务。执行
GRANT REPLICATION SLAVE ON . TO ‘repl’@‘127.0.0.1’ IDENTIFIED BY ‘mysql’;
时报错：
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘IDENTIFIED BY ‘mysql’’ at line 1
请问是什么原因呢？

Answer 1

翔仔 2020-05-11 00:17:11

同学好，说的是语法错误，试试

GRANT REPLICATION SLAVE ON *.* TO repl@'127.0.0.1' IDENTIFIED BY 'mysql';