service mysqld status //查看状态
service mysql restart //重启
mysql -u root -p //进入mysql
123456
create user "zgm"@"%" identified by "zgm";
create user "zgm2"@"mini1" identified by "zzz"; 创建用户,密码为zzz
grant all privileges on *.* to 'zgm2'@'mini1' identified by '123456' with grant option;将zgm2用户密码设置为123456,赋予所有权限
update user set password=password('123456') where user='zgm2'; 更新用户密码为123456
设置密码之后仍然不输入密码就可以登录,直接mysql -u zgm2 就可以登录
这是因为user表中有空用户,删除即可
select * from mysql.user where user='';
use mysql;
delete from user where user = '';
flush privileges;
service mysql restart