收回權(quán)限
? ? #給用戶cacti賦予所有庫(kù)的所有權(quán)限?
? ? GRANT ALL PRIVILEGES ON *.* TO 'cacti'@'%' IDENTIFIED BY 'cacti' WITH GRANT OPTION;?
? ? #重新載入賦權(quán)表?
? ? FLUSH PRIVILEGES;?
? ? #收回權(quán)限(不包含賦權(quán)權(quán)限)?
? ? REVOKE ALL PRIVILEGES ON *.* FROM cacti;?
? ? REVOKE ALL PRIVILEGES ON cacti.* FROM cacti;?
? ? #收回賦權(quán)權(quán)限?
? ? REVOKE GRANT OPTION ON *.* FROM cacti;?
? ? #重新載入賦權(quán)表?
? ? FLUSH PRIVILEGES;
