mysql创建用户并授权

2019独角兽企业重金招聘Python工程师标准>>>

一，创建数据库

create database XXX;

 

二，创建用户

CREATE USER 'username'@'host' IDENTIFIED BY 'password';

例子:
CREATE USER 'dog'@'localhost' IDENTIFIED BY '123456';

 

三，给用户授权

GRANT privileges ON databasename.tablename TO 'username'@'host'

例子:
GRANT SELECT, INSERT ON test.user TO 'pig'@'%';
GRANT ALL ON *.* TO 'pig'@'%';
GRANT ALL ON maindataplus.* TO 'pig'@'%';

 

注意:

用以上命令授权的用户不能给其它用户授权，如果想让该用户可以授权，用以下命令:

GRANT privileges ON databasename.tablename TO 'username'@'host' WITH GRANT OPTION;

 

四，撤销用户授权

REVOKE privilege ON databasename.tablename FROM 'username'@'host';

 

转载于:https://my.oschina.net/zhangmaoyuan/blog/1928174