授權該用戶(hù)所有權限，只能本機登錄: 

grant all  on databasename.tablename to username@localhost Identified by "password"; 

flush privileges; 

注:databasename指數據庫名 tablename 表名 全部表可以用* username 用戶(hù)名 password 密碼 

授權該用戶(hù)部分權限，只能某個(gè)IP段登錄： 

grant SELECT,INSERT,UPDATE,DELETE,CREATE,DROP on cbc.* to username@'192.168.1.0/255.255.255.0' Identified by "password"; 

取消授權: 

revoke all privileges on *.* from mastert@'%'   

問(wèn)題：如何關(guān)閉MYSQL某用戶(hù)禁止備份還原？