You need to GRANT the appropriate privs-for the slave in question to replicate from the master on the master. Look up Grant on mysql.com
- Dathan Vance Pattishall - Sr. Programmer and mySQL DBA for FriendFinder Inc. - http://friendfinder.com/go/p40688 -->-----Original Message----- -->From: Ilia Kantor [mailto:[EMAIL PROTECTED] -->Sent: Sunday, November 02, 2003 1:11 PM -->To: [EMAIL PROTECTED] -->Subject: replication setup --> -->Hello, --> -->I'm not so newbie to mysql yet have troubles setting up the -->replication.. Could you advise a way out ? --> -->I set up slave, master and rerun them. --> -->But when I type --> -->LOAD DATA FROM MASTER -->on slave server - I see --> -->ERROR 1218: Error connecting to master: Access denied for user: -->'[EMAIL PROTECTED]' (Using password: YES) --> -->How can that happen? --> -->mysql --host=<..> --port=<..> -u<..> -p -->connects quite well. --> --> --> --> --> -->-- -->Best regards, --> Ilia mailto:[EMAIL PROTECTED] --> --> -->-- -->MySQL General Mailing List -->For list archives: http://lists.mysql.com/mysql -->To unsubscribe: -->http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]