爱编程
mysql 远程访问设置
2015-2-9 Jessie

查询是否可以远程访问:


select * from mysql.user where host=% and user=MysqlUserName;






1.允许远程访问


grant all privileges on *.* to MysqlUserName@'%' identified by 'MysqlPassword' with grant option;


flush privileges;






2.取消远程访问


revoke all on *.* from MysqlUserName@'%';


flush privileges;