I give in my slave PC a file privilege in the same user as the master but there is still error in my log file. Deferent these time:
Slave: connected to master '[EMAIL PROTECTED]:192', replication started in log 'FIRST' at position 4 Error reading packet from server: Binary log is not open (server_errno=2000) I'll show my configuration: MASTER (192.168.0.1) [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock default-character-set=greek log-bin server-id=1 binlog-do-db=qbit.* [mysql.server] user=mysql basedir=/var/lib [safe_mysqld] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid SLAVE (192.168.0.3) [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock default-character-set=greek server-id=2 master-host=192.168.0.1 master-user=replica master-password= master-port=3306 replicate-do-db=qbit.* [mysql.server] user=mysql basedir=/var/lib [safe_mysqld] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid when i give the "SHOW SLAVE STATUS" from 192.168.0.3 I take: +-------------+-------------+-------------+---------------+----------+-----+ ---------------+-----------------+---------------------+------------+------- -----+--------------+ | Master_Host | Master_User | Master_Port | Connect_retry | Log_File | Pos | Slave_Running | Replicate_do_db | Replicate_ignore_db | Last_errno | Last_error | Skip_counter | +-------------+-------------+-------------+---------------+----------+-----+ ---------------+-----------------+---------------------+------------+------- -----+--------------+ | localhost | replica | 192 | 60 | | 4 | Yes | qbit.* | | 0 | | 0 | +-------------+-------------+-------------+---------------+----------+-----+ ---------------+-----------------+---------------------+------------+------- -----+--------------+ when i give the "SHOW MASTER STATUS" from 192.168.0.3 I take: +------+----------+--------------+------------------+ | File | Position | Binlog_do_db | Binlog_ignore_db | +------+----------+--------------+------------------+ | NULL | NULL | NULL | NULL | +------+----------+--------------+------------------+ when i give the "SHOW SLAVE STATUS" from 192.168.0.1 I take: +-------------+-------------+-------------+---------------+----------+-----+ ---------------+-----------------+---------------------+------------+------- -----+--------------+ | Master_Host | Master_User | Master_Port | Connect_retry | Log_File | Pos | Slave_Running | Replicate_do_db | Replicate_ignore_db | Last_errno | Last_error | Skip_counter | +-------------+-------------+-------------+---------------+----------+-----+ ---------------+-----------------+---------------------+------------+------- -----+--------------+ | | | 0 | 0 | | 0 | No | | | 0 | | 0 | +-------------+-------------+-------------+---------------+----------+-----+ ---------------+-----------------+---------------------+------------+------- -----+--------------+ 1 row in set (0.01 sec) when i give the "SHOW MASTER STATUS" from 192.168.0.1 I take: +----------------+----------+--------------+------------------+ | File | Position | Binlog_do_db | Binlog_ignore_db | +----------------+----------+--------------+------------------+ | server-bin.001 | 73 | qbit.* | | +----------------+----------+--------------+------------------+ 1 row in set (0.01 sec) THANX ---------------------------------------------------------------------------- ---------------------------------------------------------------------------- ----------------------------------- Am Dienstag, 29. Juli 2003 11:15 schrieb ΝΙΚΟΣ ΓΑΤΣΗΣ: > Hello. > I have MySQL 3.23.41 on a RH-7.2 Linux used as local server. > I'm trying to replicate the databases from server (192.168.0.1) to another > linux PC (192.168.0.3). > Following the manual, i grant to the master a user with file privileges, > and edit both my.cnf files. > The master starts fine but the slave mysql.log shows up an error: > > Slave thread: error connecting to master: Access denied for user: > [EMAIL PROTECTED]' (Using password: YES) (0), retry in 60 sec > I made the same mistake yesterday because the documentation says to do so. But the file privilege is not enough. Give ur replication user the "Replication Slave" right in addition and it works fine. Bernd -- One OS to rule them all, one OS to find them. One OS to bring them all, and in the darkness bind them In the land of Redmond, where the shadows lie. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
