7 messages in com.mysql.lists.mysqlRe: MySQL Database Replication
FromSent OnAttachments
Thi Cao05 Mar 2002 15:17 
James Housley05 Mar 2002 15:59 
Thi Cao06 Mar 2002 05:49 
Thi Cao06 Mar 2002 06:26 
ds07 Mar 2002 09:01 
Thi Cao07 Mar 2002 09:03 
Luc Foisy07 Mar 2002 09:55 
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

--------------------------------------------------------------------- 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!