has anyone got any idea why it wont let the slave connect properly ? here is my slave settings
port = 3307 socket = /usr/local/etc/mysqlslave/tmp/mysql.sock master-host=localhost master-user=replication master-password=******* master-port=3306 master-connect-retry=60 report-host=localhost report-port=3307 server-id=2 -----Original Message----- From: Dan Rossi [mailto:[EMAIL PROTECTED] Sent: Saturday, March 01, 2003 7:55 PM To: [EMAIL PROTECTED] Subject: RE: permissions error for the slave server hi there my sql slave server cannot replicate as its getting permissions errors dont know what happened but its not happy now 030302 7:09:24 Slave I/O thread killed while connecting to master 030302 7:09:24 Slave I/O thread exiting, read up to log 'FIRST', position 4 030302 7:09:29 Slave I/O thread: error connecting to master '[EMAIL PROTECTED]:3306': Error: 'Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)' errno: 1045 retry-time: 60 retries: 86400 i did this on the master GRANT REPLICATION SLAVE, RELOAD, SUPER ON *.* TO [EMAIL PROTECTED] IDENTIFIED BY '*****'; --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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