创建一个只读账号
GRANT SElECT ON *.* TO 'username'@'%' IDENTIFIED BY "password";
创建一个复制账号
grant replication slave, replication client on *.* to 'username'@'%' identified by "password";
刷新权限让授权生效
flush privileges;
创建一个只读账号
GRANT SElECT ON *.* TO 'username'@'%' IDENTIFIED BY "password";
创建一个复制账号
grant replication slave, replication client on *.* to 'username'@'%' identified by "password";
刷新权限让授权生效
flush privileges;