Mysql用户相关操作命令

查看密码策略

show variables like '%password%';

修改密码长度限制与密码强度限制

set global validate_password.policy=LOW;
set global validate_password.length=6;

创建用户

CREATE USER 'xxx'@'%' IDENTIFIED BY '123456';

修改用户密码

ALTER USER 'root'@'%'IDENTIFIED WITH mysql_native_password  BY 'xxxxxxxx';

刷新权限

FLUSH PRIVILEGES;

查看是否有授权权限 并给root账户设置授权权限

SELECT host,user,Grant_priv,Super_priv FROM mysql.user;
UPDATE mysql.user SET Grant_priv='Y', Super_priv='Y' WHERE User='root';

给某个用户授予某个表的权限

GRANT ALL ON `table_name`.* TO `xxx`@`%`;