备份mysql数据用的账号是直接用root 还是另外加一个backup的专用账户如果转用用户 推荐加那些权限?
GRANT SELECT,RELOAD,FILE,LOCK TABLES,SHOW VIEW ON *.* TO 'backup'@127.0.0.1 IDENTIFIED BY 'PASSWORD';
GRANT SELECT,RELOAD,FILE,LOCK TABLES,SHOW VIEW ON *.* TO 'backup'@127.0.0.1 IDENTIFIED BY 'PASSWORD';
备份是在服务器本地走的吧,一般都用root@localhost账号来进行做了。
还需要一个unlock tables的权限吧,有锁就有解啊!