主講linux高級版05 mysql權(quán)限

GRANT<privileges>ON<what>TO<user>[IDENTIFIEDBY"<password>"][WITHGRANTOPTION]whatuseridentifiedbywithgrantoption為可選項，代表本用戶可以把權(quán)限再次授給其它file:在MySQLprocess:reloadshutdown關(guān)閉MySQLall:允許做任何事(和root一樣)usage:只允許登錄–alter:修改已存在的數(shù)據(jù)表(例如增加/刪除列)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"授權(quán)dbaMySQL授權(quán)dbaMySQL–grantselecton*.*to授權(quán)dbaMySQL–granton*.*tograntgrantselect,insert,update,deleteontestdb.orderstograntgrantselect(id,se,rank)ontestdb.apache_logtograntgrantexecuteonproceduretestdb.pr_addtograntexecuteonfunctiontestdb.fn_addtouser1user