這幾天在折騰數據庫,對mysqldump所要使用到的權限做下記錄
GRANT EVENT, RELOAD, LOCK TABLES, SELECT, SHOW VIEW, REPLICATION CLIENT ON *.* TO 'db_user_backups'@'%' IDENTIFIED BY 'MWVhYzA1Yzc1YTM4';
mysqldump -uUserName -pPassWord -hHost --master-data=2 -E -F -R --triggers --add-drop-database --add-drop-table -B DataBase
f