MySql 安全设置

mysql5.7改变了默认的强制更新密码策略，提示：错误号码1862

mysql -h192.168.56.1 -uroot -p
SET PASSWORD = PASSWORD('newpassword1');
alter user 'root'@'%' password expire never;

flush privileges;

授权访问者

允许用户root从ip为192.168.1.6的主机连接到mysql服务器，并使用password1作为密码

mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.1.6' IDENTIFIED BY 'password1'; 

flush privileges;

撤销访问者

撤销用户root从ip为192.168.1.6的主机连接到mysql服务器

mysql> REVOKE ALL PRIVILEGES ON *.* FROM 'root'@'192.168.1.6';

flush privileges;

删除用户

drop user 'root'@'192.168.1.6';

查看MYSQL数据库中所有用户

mysql> SELECT DISTINCT CONCAT('User: ''',user,'''@''',host,''';') AS query FROM mysql.user;