MySql用户创建授权以及删除

Posted on In 
CREATE USER yy IDENTIFIED BY '123';

如果要限制在固定地址登陆，比如localhost 登陆：
CREATE USER yy@localhost IDENTIFIED BY '123';

grant:
GRANT ALL PRIVILEGES ON *.* TO user@localhost;

grant select,insert,update,delete on *.* to test1@"%" Identified by "abc";
格式：grant select on 数据库.* to 用户名@登录主机 identified by "密码"