MYSQL Replication problem

Hal Burgiss hal at burgiss.net
Wed Jul 30 18:47:25 UTC 2008


On Mon, Jul 28, 2008 at 02:38:58PM -0400, Hal Burgiss wrote:
> 
> This is a simple one to one set up. Slave is 8.04LTS server, fully
> upgraded, and the master is CentOS mysql 5.0. I have done this step by
> step using 4 different HOWTOs and I get the same result: it *seems*
> to work, in that there are no errors or obvious complaining, but I
> always get:
> 
>            Slave_IO_Running: No
>            Slave_SQL_Running: Yes

For the record, the apparent cause was that multiple slave users had
been created, but only one had replication privileges. And naturally
during the replication handshake the slave was working consistently
with the wrong credentials.

-- 
Hal
 




More information about the ubuntu-users mailing list