Jeetendra,
Can you paste the error log here. -D -----Original Message----- From: Jeetendra Ranjan [mailto:[email protected]] Sent: Thursday, December 24, 2009 1:49 PM To: Parikh, Dilip Kumar; [email protected] Subject: Re: Slave is not updated Hi Dilip, Thanks for your response I already run the below command at master: grant replication slave on *.* to 'mysqladm'@'95.84.86.41' identified by 'admmysql'; Thanks Jeetendra Ranjan ----- Original Message ----- From: "Parikh, Dilip Kumar" <[email protected]> To: "Jeetendra Ranjan" <[email protected]>; <[email protected]> Sent: Thursday, December 24, 2009 1:10 PM Subject: RE: Slave is not updated > You can see connecting to master means it is not able to establish the > connection from slave to master, give the grants as (replication client > etc..) > and then try again. > > Thanks, > Dilipkumar > Database Engineering > Pager mail:[email protected] > > -----Original Message----- > From: Jeetendra Ranjan [mailto:[email protected]] > Sent: Thursday, December 24, 2009 1:05 PM > To: [email protected] > Subject: Slave is not updated > > Hi, > > I am getting this information from slave > > mysql> show slave status \G; > *************************** 1. row *************************** > Slave_IO_State: Connecting to master > Master_Host: 201.107.236.77 > Master_User: root > Master_Port: 3306 > Connect_Retry: 60 > Master_Log_File: ip-201-107-236-77-bin.000042 > Read_Master_Log_Pos: 4702 > Relay_Log_File: ip-95-84-86-41-relay-bin.000001 > Relay_Log_Pos: 98 > Relay_Master_Log_File: ip-201-107-236-77-bin.000042 > Slave_IO_Running: No > Slave_IO_Running: Yes > Replicate_Do_DB: > Replicate_Ignore_DB: > Replicate_Do_Table: > Replicate_Ignore_Table: > Replicate_Wild_Do_Table: > Replicate_Wild_Ignore_Table: > Last_Errno: 0 > Last_Error: > Skip_Counter: 0 > Exec_Master_Log_Pos: 4702 > Relay_Log_Space: 98 > Until_Condition: None > Until_Log_File: > Until_Log_Pos: 0 > Master_SSL_Allowed: No > Master_SSL_CA_File: > Master_SSL_CA_Path: > Master_SSL_Cert: > Master_SSL_Cipher: > Master_SSL_Key: > Seconds_Behind_Master: NULL > > > The Slave_IO_Running is always No even after repeating below steps so > many times > > stop slave > > CHANGE MASTER TO .... > > and > > start slave > > > > Please guide why this is always NO and how do i enable it ? > > Regards > Jeetendra Ranjan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[email protected] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[email protected]
