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