主讲linux高级版05 mysql权限

GRANT<privileges>ON<what>TO<user>[IDENTIFIEDBY"<password>"][WITHGRANTOPTION]whatuseridentifiedbywithgrantoption为可选项，代表本用户可以把权限再次授给其它file:在MySQLprocess:reloadshutdown关闭MySQLall:允许做任何事(和root一样)usage:只允许登录–alter:修改已存在的数据表(例如增加/删除列)create:deletedropindexinsert:select显示/updateall影响除WITHGRANTOPTIONalterall影响除WITHGRANTOPTIONaltercreatecreatetemporarycreatecreate影响SELECTINTOOUTFILE和影响SELECTINTOOUTFILE和LOADDATAINFILEgrantlock影响SHOWPROCESSLISTreplicationreplicationreplicationshowshow影响SHOWreplicationshowshow影响SHOWCREATEVIEWthread、mysqladmindebug、PURGEMASTERLOGS和SETGLOBALshowgrantsforrevokegrantto”revokeallprivilegeson*.*fromflushgrantselect,insert,update,deleteontestdb.*tograntMySQLgrantcreate,alter,dropontestdb.*tograntMySQLgrantreferencesontestdb.*tograntMySQLgrantcreatetemporarytablesontestdb.*tograntMySQLgrantindexontestdb.*tograntMySQLgrantMySQL–grantcreateviewontestdb.*to–grantviewontestdb.*tograntMySQLgrantcreateroutineontestdb.*tograntalterroutineontestdb.*tograntexecuteontestdb.*tograntDBAMySQLgrantallprivilegesontestdbto"privileges"授权dbaMySQL授权dbaMySQL–grantselecton*.*to授权dbaMySQL–granton*.*tograntgrantselect,insert,update,deleteontestdb.orderstograntgrantselect(id,se,rank)ontestdb.apache_logtograntgrantexecuteonproceduretestdb.pr_addtograntexecuteonfunctiontestdb.fn_addtouser1user