mysql> create user '用戶名'@'被允許連接的主機(jī)名稱或主機(jī)的IP地址' identified by '用戶密碼';
mysql> select user,host from mysql.user;

mysql> create user 'hhy'@'localhost' identified by '123';
/*或*/
mysql> create user 'hhy'@'127.0.0.1' identified by '123';

mysql> create user 'test'@'192.1668.44.110' identified by '123';

# yum install mysql -y
# mysql -h 192.168.44.110 -P 3306 -uharry -p
Enter password:123

create user 'jack'@'192.168.44.%' identified by '123'

create user 'root'@'%' identified by '123';

drop user 'hhy'@'localhost';

drop user 'jack'@'192.168.44.%';

mysql> create user 'harry'@'localhost' identified by '123';
mysql> create user 'harry'@'192.168.44.110' identified 

mysql> drop user 'harry'@'192.168.44.110';

mysql> delete from mysql.user where user='root' and host='%';
mysql> flush privileges;

mysql> rename user 舊用戶信息 to 新用戶信息;

mysql> rename user 'root'@'%' to 'root'@'10.1.1.%';

mysql> create user 'tom'@'localhost' identified by '123';
mysql> rename user 'tom'@'localhost' to 'hhy'@'localhost';

mysql> update mysql.user set user='hhy',host='localhost' where user='tom' and host='localhost';

mysql> flush privileges;

USAGE	無(wú)權(quán)限,只有登錄數(shù)據(jù)庫(kù),只可以使用test或test_*數(shù)據(jù)庫(kù)
ALL		所有權(quán)限
以下權(quán)限為指定權(quán)限
select/update/delete/super/replication slave/reload...
with grant option 選項(xiàng)表示允許把自己的權(quán)限授予其它用戶或者從其他用戶收回自己的權(quán)限

create database java;
use java;
create table tb_student(
	id mediumint not null auto_increment,
	name varchar(20),
	age tinyint unsigned default 0,
	gender enum('男','女'),
	address varchar(255),
	primary key(id)
) engine=innodb default charset=utf8;

insert into tb_student values (null,'劉備',33,'男','湖北省武漢市');
insert into tb_student values (null,'貂蟬',18,'女','湖南省長(zhǎng)沙市');
insert into tb_student values (null,'關(guān)羽',32,'男','湖北省荊州市');
insert into tb_student values (null,'大喬',20,'女','河南省漯河市');
insert into tb_student values (null,'趙云',25,'男','河北省石家莊市');
insert into tb_student values (null,'小喬',18,'女','湖北省荊州市');

mysql> grant 權(quán)限1,權(quán)限2 on 庫(kù).表 to 用戶@主機(jī)
mysql> grant 權(quán)限(列1,列2,...) on 庫(kù).表 to 用戶@主機(jī)

mysql> grant select on java.* to 'hehanyu'@'192.168.44.%';

mysql> flush privileges;

mysql> grant update(age) on java.tb_student to 'hehanyu'@'192.168.44.%';

mysql> flush privileges;

create user 'root'@'%' identified by '123';
grant all on *.* to 'root'@'%';
flush privileges;

mysql> show grants;

mysql> show grants for '用戶名稱'@'授權(quán)的主機(jī)名稱或IP地址';

mysql> grant all on *.* to 'amy'@'10.1.1.%' identified by '123' with grant option;
mysql> grant all on *.* to 'harry'@'10.1.1.%' identified by '123'; 

revoke 權(quán)限 on 庫(kù).表 from 用戶;
查看hehanyu用戶權(quán)限
mysql> show grants for 'hehanyu'@'192.168.44.%';
撤消指定的權(quán)限
mysql> revoke update on java.tb_student from 'tom'@'192.168.44.%';
撤消所有的權(quán)限
mysql> revoke select on java.* from 'tom'@'192.168.44.%';