MySQL权限管理

创建用户

create user zhx identified by '123456'

查看用户表

select User from mysql.user group by User;

权限分配

grant all privileges on *.* to zhx@'192.168.199.220' 授权完毕之后要刷新权限 flush privileges;

root 用户无法登陆

1. 进入安全模式 mysqld_safe --user=mysql --skip-grant-tables --skip-networking & mysql -u root mysql UPDATE user SET Password=PASSWORD('123456') where USER='root';