钝刀的家

MySQL的操作权限完整列表，解释了user，db，host等等表中对应列的操作权限。

对用户管理很有帮助的参考信息。

用户的具体创建和授权，可以参考相关文档，都有比较详细的说明，这里就不列出了。

MYSQL版本5.1。

'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' 'Functions,Procedures' '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'
'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'
'Update' 'Tables' 'To update existing rows'
'Usage' 'Server Admin' 'No privileges - allow connect only'

一些简单的linux下的环境配置说明，初学者可以看看

用source /etc/profile 可以导入文件，不用重新启动