MySQL Forums
Forum List  »  Replication

How to allow connection between master and slave
Posted by: Jörg Nowak
Date: November 22, 2005 02:50AM

Hello,

I try to configure a replication (reading the chapter 6 of documentation).

I did all the steps and I get the following error message in the log file of the slave:

051121 18:37:27 [ERROR] Slave I/O thread: error connecting to master 'mysql@10.1.2.25:3306': Error: 'Host '10.1.2.34' is not allowed to connect to this MySQL server' errno: 1130 retry-time: 60 retries: 86400

But in the table mysql.host on master side (10.1.2.25) I have the entry:
+---------------+-----+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+-----------------------+------------------+------------------+----------------+---------------------+--------------------+--------------+
| Host | Db | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Grant_priv | References_priv | Index_priv | Alter_priv | Create_tmp_table_priv | Lock_tables_priv | Create_view_priv | Show_view_priv | Create_routine_priv | Alter_routine_priv | Execute_priv |
+---------------+-----+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+-----------------------+------------------+------------------+----------------+---------------------+--------------------+--------------+
| 10.1.2.34 | | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y |
+---------------+-----+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+-----------------------+------------------+------------------+----------------+---------------------+--------------------+--------------+

What else I have to do to allow the connection between master and slave ?

Joerg Nowak

Options: ReplyQuote


Subject
Views
Written By
Posted
How to allow connection between master and slave
2796
November 22, 2005 02:50AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.