7 messages in com.mysql.lists.mysqlRe: MySQL Database Replication| Subject: | Re: MySQL Database Replication![]() |
|---|---|
| From: | James Housley (ji...@thehousleys.net) |
| Date: | 03/05/2002 03:59:54 PM |
| List: | com.mysql.lists.mysql |
Thi Cao wrote:
Hello everyone,
This is my first attempt at MySQL database replication. Can't seem to get it to work yet. The problem reported in the error log of the slave server is as follows:
Error reading packet from server: Access denied for user 'repl@slave_host' (Using password: YES) (read_errno 0,server_errno=1045)
I believe it has something to do with the way I granted privileges to the user repl. I did the following:
GRANT FILE ON dbname.* to repl@'%' identified by 'some_password';
Did you do a FLUSH PRIVILIGES after that? That is needed in some cases.
Jim
-- /"\ ASCII Ribbon Campaign . \ / - NO HTML/RTF in e-mail . X - NO Word docs in e-mail . / \ ----------------------------------------------------------------- je...@FreeBSD.org http://www.FreeBSD.org The Power to Serve ji...@TheHousleys.Net http://www.TheHousleys.net jhou...@SimTel.Net http://www.SimTel.Net
--------------------------------------------------------------------- Studies show that 1 out of every 4 Americans suffer some form of mental illness. So look at your three best friends, if they are okay it is YOU!




