Mysql用户相关操作命令 迁移
查看密码策略
sql
show variables like '%password%';
修改密码限制
sql
# 修改密码强度
set global validate_password.policy=LOW;
# 修改密码长度
set global validate_password.length=6;
创建用户
sql
CREATE USER 'xxx'@'%' IDENTIFIED BY '123456';
修改用户密码
sql
ALTER USER 'root'@'%'IDENTIFIED WITH mysql_native_password BY 'xxxxxxxx';
刷新权限
sql
FLUSH PRIVILEGES;
查看权限
sql
SELECT host,user,Grant_priv,Super_priv FROM mysql.user;
# 给root账户设置授权权限
UPDATE mysql.user SET Grant_priv='Y', Super_priv='Y' WHERE User='root';
给用户授予表权限
sql
GRANT ALL ON `table_name`.* TO `xxx`@`%`;