> SHOW GRANTS FOR 'repluser'@'replmachine'; yes there is file grant on *.* - i used a simple password to avoid writing it wrong. as i said, if i connect with mysql client tool from the slave machine, i CAN login into the master server! Only the slave can't login into the master server (with the same authentication data!)
> > (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'; i did that - as described in the manual! --------------------------------------------------------------------- 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
