mysql

CentOS7 mysql授权和取消授权远程访问

授权远程访问操作如下三步:

1.use mysql;
2.grant all privileges on *.* to 'root'@'%' identified by 'password';
3.flush privileges;

取消授权远程访问操作如下:

1.use mysql;
2.revoke all privileges on *.* from 'root'@'%';
3.flush privileges;