ユーザー管理と権限と設定 - mysql

mysql>use mysql;

mysql>select host,user,password from user ;

mysql>create user zx_root;

mysql>rename user feng to newuser; //mysql 5之后可以使用，之前需要使用update 更新user表

mysql>drop user newuser;   //mysql5之前删除用户时必须先使用revoke 删除用户权限，然后删除用户，mysql5之后drop 命令可以删除用户的同时删除用户的相关权限

mysql>set password for zx_root =password('xxxxxx');
mysql>update  mysql.user  set  password=password('xxxx')  where user='otheruser'

mysql>show grants for zx_root;

mysql>grant select on dmc_db.*  to zx_root;

mysql>revoke  select on dmc_db.*  from  zx_root;  //如果权限不存在会报错

mysql>grant select，update，delete  ，insert  on dmc_db.*  to  zx_root;

flush  privileges ;

grant select on testdb.* to common_user@'%'
grant insert on testdb.* to common_user@'%'
grant update on testdb.* to common_user@'%'
grant delete on testdb.* to common_user@'%'

grant select, insert, update, delete on testdb.* to common_user@'%'

grant create on testdb.* to developer@'192.168.0.%';
grant alter on testdb.* to developer@'192.168.0.%';
grant drop on testdb.* to developer@'192.168.0.%';

grant references on testdb.* to developer@'192.168.0.%';

grant create temporary tables on testdb.* to developer@'192.168.0.%';

grant index on testdb.* to developer@'192.168.0.%';

grant create view on testdb.* to developer@'192.168.0.%';
grant show view on testdb.* to developer@'192.168.0.%';

grant create routine on testdb.* to developer@'192.168.0.%'; -- now, can show procedure status
grant alter routine on testdb.* to developer@'192.168.0.%'; -- now, you can drop a procedure
grant execute on testdb.* to developer@'192.168.0.%';

grant all privileges on testdb to dba@'localhost'

grant all on *.* to dba@'localhost'

grant select on *.* to dba@localhost; -- dba 可以查询 MySQL 中所有数据库中的表。
grant all on *.* to dba@localhost; -- dba 可以管理 MySQL 中的所有数据库

grant select on testdb.* to dba@localhost; -- dba 可以查询 testdb 中的表。

grant select, insert, update, delete on testdb.orders to dba@localhost;

grant select(id, se, rank) on testdb.apache_log to dba@localhost;