Dear Soenke, > i wanna setup replication, everything works so far, but the slave > can'tconenct to the master, access denied. but if i connect with the 'mysql' > program from slave machine to master machine, it works!
Before you go crazy, check if the slave (user) has sufficient privileges. Let's say the slave user is called "repluser" which connects from "replmachine". In this case you do SHOW GRANTS FOR 'repluser'@'replmachine'; (on the master server, of course). Check for the FILE privilege. The slave user won't need anything else. It doesn't need SELECT or whatever, only FILE. On the master server, you can do the following: DELETE FROM mysql.user WHERE User = 'repluser'; DELETE FROM mysql.db WHERE User = 'repluser'; FLUSH PRIVILEGES; GRANT FILE ON *.* [or only on the database you want to replicate] TO 'repluser'@'replmachine' IDENTIFIED BY 'some-password'; Now, your slave should be able to replicate from the master. Hope it helps. Regards, -- Stefan Hinz <[EMAIL PROTECTED]> CEO / Geschäftsleitung iConnect GmbH <http://iConnect.de> Heesestr. 6, 12169 Berlin (Germany) Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 ----- Original Message ----- From: "Sönke Ruempler" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, November 24, 2002 11:53 AM Subject: problem with replication > hello, > > i wanna setup replication, everything works so far, but the slave > can'tconenct to the master, access denied. but if i connect with the 'mysql' > program from slave machine to master machine, it works! > > going crazy .. both mysqld's are 3.23.53 ! > > what is going wrong here ahh? > > regards, soenke. > > > --------------------------------------------------------------------- > 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
