Hi, I resubmited again for anyone with solution to assist me.
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 --------------------------------------------------------------------- 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
