Hi,
It looks like your slave can't connect to the master you've defined.
Here are the steps you need to follow :
1- On shell type
mysql -h mail.dbi.tju.edu -urepl -pPASSWORD
You need to replace word PASSWORD with your actual password. This will
show you if you can connect to master from your slave computer. If you
can not connect check your password and make sure that on master server
user 'repl' has permission to access from your slave computer. You can
see permissions by checking user table on mysql db.
2- If you can access to master server from slave next step is : make
sure that you have entered your password correctly to /etc/my.cnf file.
You can chance your replication user's password by typing
change master to master_user = 'repl', master_password = 'PASSWORD'
After all these steps type 'start slave' on slave server to see if it is
working.
Kayra Otaner
On Fri, 2003-08-29 at 15:10, Leo Genyuk wrote:
> I am having problems to start MySQL replication. I followed all the
> steps outlined on the website, but replicaiton is not working. slave
> status shows the following:
>
> mysql> show slave status\G
> *************************** 1. row ***************************
> Master_Host: mail.dbi.tju.edu
> Master_User: repl
> Master_Port: 3306
> Connect_retry: 60
> Master_Log_File: mail-bin.001
> Read_Master_Log_Pos: 3651
> Relay_Log_File: blade4-relay-bin.001
> Relay_Log_Pos: 3133
> Relay_Master_Log_File: mail-bin.001
> Slave_IO_Running: No
> Slave_SQL_Running: Yes
> Replicate_do_db:
> Replicate_ignore_db:
> Last_errno: 0
> Last_error:
> Skip_counter: 0
> Exec_master_log_pos: 3651
> Relay_log_space: 3133
> 1 row in set (0.00 sec)
>
>
> As you can see Slave_IO_Running is set to NO.
>
> I tried to start it manually with the follwoing command:
> slave start IO_THREAD;
> without any luck. I have also tried to start and stop the slave server
> also wihtout any luck.
>
> Thank you in advance for any help.
>
> Leo.
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
