中职对口升学mysql权限表

ALTER TABLE.Allows useofAlters ordrops stored routines.ALTERCREATE TABLE.Allows useofALTER ROUTINECreatesstoredroutines.CREATECREATE TEMPORARYTABLE.Allows use OfCREATE ROUTINECREATECREATEUSER,DROP USER,RENAME USER,Allows useOf andTEMPORARYTABLEREVOKE ALLPRIVILEGES.CREATE USERCREATEVIEW.Allows useofDELETE.Allows useofCREATE VIEWDROPTABLE.Allows useofDELETEAllows theuser torun storedroutines.DROPSELECT...INTO OUTFILELOAD DATAAllows useOfandEXECUTEINFILE.FILECREATE INDEXDROP INDEX.Allows useof andINSERT.Allows useofINDEX INSERTLOCKTABLESAllows useof ontables forwhich theuser alsoLOCKTABLESSELECThas privileges.SHOW FULLPROCESSLIST.Allows useOfFLUSH.Allows useofPROCESSAllows theuser toask whereslave ormasterRELOADservers are.REPLICATIONNeeded forreplication slaves.CLIENTREPLICATIONSELECT.Allows useofSLAVESHOW DATABASES.Allows useOfSELECTSHOW CREATEVIEW.Allows useOfSHOWmysqladmin shutdown.Allows useofDATABASESCHANGE MASTER,KILL,PURGE MASTERLOGS,Allows useof andSHOWVIEWSET GLOBALmysqladmin debugSQLstatements.AllowsSHUTDOWNcommand.Allows oneextra connectionto bemade ifSUPERmaximumconnections arereached.UPDATE.AllowsuseofAllows connectionwithout anyspecific privileges.UPDATEUSAGE。