On Wed, Sep 26, 2001 at 12:44:44PM +0300, Razvan CATINAS wrote:
> Hi!
>
> I am trying to replicate a database from one host (master) to other host
> (slave), but on slave machine I got this error messages:
>
> 010926 11:24:09 Slave thread: error connecting to master:Access denied
> for user: '0@localhost' (Using password: YES)(0), retry in 0 sec
> 010926 11:24:09 Slave thread: error connecting to master:Access denied
> for user: '0@localhost' (Using password: YES)(0), retry in 0 sec
> 010926 11:24:09 Slave thread: error connecting to master:Access denied
> for user: '0@localhost' (Using password: YES)(0), retry in 0 sec
> 010926 11:24:09 Slave thread: error connecting to master:Access denied
> for user: '0@localhost' (Using password: YES)(0), retry in 0 sec
> 010926 11:24:09 Slave thread: error connecting to master:Access denied
> for user: '0@localhost' (Using password: YES)(0), retry in 0 sec
>
> In /etc/my.cnf, I have this lines:
>
> [mysqld]
> master-host=192.168.111.1
> master-user=user
> master-password=password
> server-id=40
> replicate-do-db=DB
> replicate-ignore-table=DB.logs
>
> I really don't understand why I have those error messages....Why
> it's trying to connect to the master with "0@localhost"? On the
> slave I have mysql3.23.32.
Nuke the master.info file and try again.
(I still need to convince Sasha that there's a good way to handle this
case...)
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936
MySQL 3.23.41-max: up 20 days, processed 390,725,230 queries (217/sec. avg)
---------------------------------------------------------------------
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