16.删除匿名用户、IPV6用户
delete from mysql.user where user='';
delete from mysql.user where user='root' and host='::1';
17.再次查看用户列表
select user, host, password from mysql.user;
复制代码
18.修改root用户密码
set password for root@localhost=password('password');
set password for root@rachel=password('XXXXXX');
set password for root@'127.0.0.1'=password('XXXXXX');