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;

查看权限

SELECT host,user,Grant_priv,Super_priv FROM mysql.user;
# 给root账户设置授权权限
UPDATE mysql.user SET Grant_priv='Y', Super_priv='Y' WHERE User='root';

给用户授予表权限

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