On Sun, Mar 11, 2001 at 06:16:22PM +0100, Rick Jansen - Tweakers.net wrote:
> Hi there,
>
> I'm trying to set up replication. But it's not working, for some
> strange reason. This is the error out of the slave log: 010311
> 18:11:25 Slave thread: error connecting to master:Access denied for
> user: 'repl@athena' (Using password: YES)(0), retry in 60 sec
>
> When i try to connect "manually", ie using the mysql tool, it works
> like it should. I get in with no problems. There are no errors in
> the master server logfile. Any idea what's going on here?
What if you remove the "master.info" file on the slave and restart the
replication?
I've found something that I haven't reported as a bug, but I probably
should. If you start replication, the slave stores the replication
info in the master.info file. If you stop replication and the change
the parameters in your my.cnf file, mysql reads the master.info file
but never "sees" the changes you made in my.cnf. It just uses the old
values in master.info.
I've noted it in the on-line docs (in the comments at the end):
http://www.mysql.com/doc/T/r/Troubleshooting_Replication.html
but it should either be integrated into the docs or fixed. I'll find
out if it is a bug or not first, I guess.
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 328-7878 Fax: (408) 530-5454
Cell: (408) 439-9951
---------------------------------------------------------------------
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
