mysql8.0用户操作和授权

mysql -V

# 创建用户
create user ‘username‘@‘ip地址‘ identified by ‘密码‘;
# 用户重命名
rename user ‘username‘@‘ip地址‘ to ‘new_username‘@‘ip地址‘;
# 改变用户密码
alter user ‘username‘@‘ip地址‘ identified by ‘新密码‘;
# 删除用户
drop user ‘username‘@‘ip地址‘;

# 查看权限
show grants for ‘username‘@‘ip地址‘
# 授权
grant 权限 on 数据库名.表名 to ‘username‘@‘ip地址‘;
# 收回授权
revoke 权限 on 数据库名.表名 from ‘username‘@‘ip地址‘;