mysql用户创建与授权

创建用户

CREATE USER ‘username’@‘host’ IDENTIFIED BY ‘password’

示例：
例子: CREATE USER ‘dog’@‘localhost’ IDENTIFIED BY ‘123456’;
CREATE USER ‘pig’@‘192.168.1.101_’ IDENDIFIED BY ‘123456’;
CREATE USER ‘pig’@’%’ IDENTIFIED BY ‘123456’;
CREATE USER ‘pig’@’%’ IDENTIFIED BY ‘’;
CREATE USER ‘pig’@’%’;

%表示全部ip都能访问；

授权

grant select,insert,update,delete,create,drop on vtdc.employee to joe@10.163.225.87 identified by ‘123′;
给来自10.163.225.87的用户joe分配可对数据库vtdc的employee表进行select,insert,update,delete,create,drop等操作的权限，并设定口令为123。

grant select,insert,update,delete,create,drop on vtdc.* to joe;
给用户joe分配可对数据库vtdc的全部表进行select,insert,update,delete,create,drop等操作的权限

给用户joe授予数据库全部权限
grant all privileges on . to joe;

刷新系统权限（修改权限时使用）
flush privileges;