revoke riˈvōk 撤销
put an end to the validity or operation of (a decree, decision, or promise).
privilege ˈpriv(ə)lij 特权
a special right, advantage, or immunity granted or available only to a particular person or group of people.
education is a right, not a privilege
grant 发放
a sum of money given by an organization, especially a government, for a particular purpose.
The money is used for small grants to deserving organizations and individuals.
本文的注释全是为了方便起见而写，sql不是这样注释的。
create user 'u1'@'localhost' identified by '12345';//在localhost 创建一个叫u1的用户， 密码为12345 set password for 'u1'@'localhost' = '12345'; //将密码设置为12345
GRANT select ON book_reader_db.book TO 'u1'@'localhost'; //给u1 赋予在book表内select的权限
revoke select on what from 'u1'@'localhost';
grant all privileges on book_reader_db.* to 'u1'@'localhost'; //给u1 操作数据库所有表的权限
revoke all privileges on book_reader_db.* from 'u1'@'localhost';//取消权限
revoke all on book_reader_db.* from 'u1'@'localhost'; //少写一个privileges...最好还是把这个单词背下来。。。
flush privileges; //刷新权限 show grants for 'u1'@'localhost'; //显示u1的所有权限
GRANT SELECT ON `book_reader_db`.`book` TO `u1`@`localhost` WITH GRANT OPTION //给u1权限的同时也让u1有权力给别的用户权限。 grant create user on *.* to 'user'@'host'; 赋予创建用户的权限。 revoke create user on *.* from 'u1'@'localhost'; 删除创建用户的权限。
上面3条语句都需要重启数据库才能生效
至于怎样重启数据库。。。
打开命令行输入net stop mysql和net start mysql 就好。。。
我现在在也很想知道怎么撤销给别人权限的权限，除了用revoke all.....
select * from mysql.user;
显示所有的用户
show grants for 'u1'@'localhost';
显示特定用户的权限