Hi, I had one question. I would like to set permission for remotely backup using mysqldump. Let's assume I want to use B(10.0.0.2) server to remotely backup A(10.0.0.1) server.
The command I run at B server are: mysqldump --opt -h10.0.0.1 -uadmin -pXXX comers > comers.txt (p/s : I want to dump comers database at A to comers.txt file in B server) On A server, I set permission: Grant file on *.* to [EMAIL PROTECTED] identified by 'XXX'; However, when I executed the mysqldump command, it hang and when I press Ctrl+C, I get the following error: mysqldump: Got error: 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) when trying to connect My Question now is, what permission I need to give to [EMAIL PROTECTED] to finish the mysqldump process and at the same time, admin user are not allowed to login into the Mysql console at A server and view other database information. (That why I can't give admin select privileges). Anyone who had solution please help me to solve this problem. Thank you in advance. Regards, Emanduel Chan Tain Por System Engineer DotCom Consulting Sdn Bhd DID : 603-62763230 ext. 112 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
