AImager

# 显示当前用户对各数据库的权限
show grants;

# 显示完整用户
SELECT DISTINCT CONCAT('User: ''',user,'''@''',host,''';') AS query FROM mysql.user;

# 创建用户
create user 'yucong'@'%' identified by 'password';

# 5.7以前修改用户密码
UPDATE user SET password=PASSWORD('password') WHERE user='user_name';

# 5.7修改用户密码
alter user 'root'@'localhost' identified by 'root';

# 授权全部权限
GRANT ALL ON *.* TO 'username'@'%';

# 刷新权限
FLUSH PRIVILEGES;