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

Reply via email to