Mysql远程授权访问账户

CREATE USER '账号'@'授权IP' IDENTIFIED BY PASSWORD '密码';
GRANT SHOW DATABASES, PROCESS, REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO '账号'@'授权IP';
GRANT SELECT ON *.*  TO '账号'@'授权IP';

标签

发表评论