Replication Problem Access Denied at Target

[denpsia]

Hi everybody,
I have put mysqldump and mysql commands on a Batch file and execute it at command prompt. But unable to access the other computer. How Can i resolve this? Advanced Thanks.

Batch File Content:

mysqldump --host=192.150.1.164 --user=test --password=test jobs_db jobs > jobs.sql

mysql --host=192.150.1.166 --user=test --password=test jobs_db < jobs.sql

mysqldump --host=192.150.1.166 --user=test --password=test jobs_db tasks > tasks.sql

mysql --host=192.150.1.164 --user=test --password=test jobs_db < tasks.sql



Code: (Executed at DOS Command Prompt)

C:\>replicate_script.bat , then I press enter key



Error Message:

ERROR 1044 (42000) at line 20: Access denied for user 'guest'@'%' to database 'jobs_db'



denpsia



Edited 1 time(s). Last edit at 10/12/2005 12:07AM by denpsia.