ITPub博客

首页 > 数据库 > MySQL > mysql 授权

mysql 授权

原创 MySQL 作者:mhabbyo 时间:2014-04-03 11:12:40 0 删除 编辑
最简单,最直接的mysql授权方式,以前那种查网页,看别人写语句的方法真是弱爆了

就两步,先 show privileges;  显示出来所有的权限,然后想怎么授就怎么授

举例如下:

root@localhost : test > show privileges;
+-------------------------+---------------------------------------+-------------------------------------------------------+
| Privilege               | Context                               | Comment                                               |
+-------------------------+---------------------------------------+-------------------------------------------------------+
| Alter                   | Tables                                | To alter the table                                    |
| Alter routine           | Functions,Procedures                  | To alter or drop stored functions/procedures          |
| Create                  | Databases,Tables,Indexes              | To create new databases and tables                    |
| Create routine          | Databases                             | To use CREATE FUNCTION/PROCEDURE                      |
| Create temporary tables | Databases                             | To use CREATE TEMPORARY TABLE                         |
| Create view             | Tables                                | To create new views                                   |
| Create user             | Server Admin                          | To create new users                                   |
| Delete                  | Tables                                | To delete existing rows                               |
| Drop                    | Databases,Tables                      | To drop databases, tables, and views                  |
| Event                   | Server Admin                          | To create, alter, drop and execute events             |
| Execute                 | Functions,Procedures                  | To execute stored routines                            |
| File                    | File access on server                 | To read and write files on the server                 |
| Grant option            | Databases,Tables,Functions,Procedures | To give to other users those privileges you possess   |
| Index                   | Tables                                | To create or drop indexes                             |
| Insert                  | Tables                                | To insert data into tables                            |
| Lock tables             | Databases                             | To use LOCK TABLES (together with SELECT privilege)   |
| Process                 | Server Admin                          | To view the plain text of currently executing queries |
| Proxy                   | Server Admin                          | To make proxy user possible                           |
| References              | Databases,Tables                      | To have references on tables                          |
| Reload                  | Server Admin                          | To reload or refresh tables, logs and privileges      |
| Replication client      | Server Admin                          | To ask where the slave or master servers are          |
| Replication slave       | Server Admin                          | To read binary log events from the master             |
| Select                  | Tables                                | To retrieve rows from table                           |
| Show databases          | Server Admin                          | To see all databases with SHOW DATABASES              |
| Show view               | Tables                                | To see views with SHOW CREATE VIEW                    |
| Shutdown                | Server Admin                          | To shut down the server                               |
| Super                   | Server Admin                          | To use KILL thread, SET GLOBAL, CHANGE MASTER, etc.   |
| Trigger                 | Tables                                | To use triggers                                       |
| Create tablespace       | Server Admin                          | To create/alter/drop tablespaces                      |
| Update                  | Tables                                | To update existing rows                               |
| Usage                   | Server Admin                          | No privileges - allow connect only                    |
+-------------------------+---------------------------------------+-------------------------------------------------------+
31 rows in set (0.00 sec)

grant create,alter,drop,delete,update,insert,select  on `test.test` to 'admin'@'192.168.8.212' ;
grant Create routine,Alter routine,Event,Execute  on eccoredb.*   to 'admin'@'192.168.8.212';
grant select on eccoredb.*   to 'admin'@'192.168.8.212';
flush privileges;
show grants for 'admin'@'192.168.8.212';

+-------------------------------------------------------------------------------------------------------------------------------------------+
| Grants for admin@192.168.8.212                                                                                                            |
+-------------------------------------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'admin'@'192.168.8.212'                                                                                             |
| GRANT EXECUTE, CREATE ROUTINE, EVENT ON `eccoredb`.* TO 'admin'@'192.168.8.212'                                                           |
| GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER ON `test`.`test.test` TO 'admin'@'192.168.8.212' |
+-------------------------------------------------------------------------------------------------------------------------------------------+
3 rows in set (0.00 sec)






来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29291882/viewspace-1135268/,如需转载,请注明出处,否则将追究法律责任。

上一篇: mysql 的连接方式
下一篇: mysql 字符集修改
请登录后发表评论 登录
全部评论

注册时间:2013-12-23

  • 博文量
    56
  • 访问量
    106647