笔记-MySql允许用户远程访问

mysql，root登录后执行下列语句：

grant insert,select,update,delete on `cloud`.* to '$user'@'$PAAS_IP' identified by '$mysql_pwd';
FLUSH PRIVILEGES;


//允许所有用户访问所有权限。
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'admin123' WITH GRANT OPTION;
FLUSH PRIVILEGES;

GRANT ALL PRIVILEGES ON *.* TO 'root'@'10.10.6.63' IDENTIFIED BY 'admin123' WITH GRANT OPTION;

FLUSH PRIVILEGES;

//查看权限
show GRANTS for root@'10.10.6.63'

//撤销具体权限
revoke  SELECT, INSERT, UPDATE, DELETE  on cloud.* from root@"10.10.6.63"

//查看具体用户的具体权限
select * from mysql.user;

举例：

可以参考：

https://blog.csdn.net/anzhen0429/article/details/78296814

https://blog.csdn.net/qq_21187515/article/details/92618885