创建用户
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;