mysql 授权 process_mysql 授权

最简单，最直接的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/，如需转载，请注明出处，否则将追究法律责任。