mysql 用户创建和授权

进入 use mysql;

创建用户 create user 用户名 identified by 密码

create user visitor identified by 'visitor';

修改权限

update user set Select_priv = 'Y' where user = 'visitor';

或创建和授权

grant SELECT on *.* to 'visitor'@'%' identified by '123456';

马上生效

FLUSH PRIVILEGES;

删除用户

DROP USER 'visitor'@'%';