You can see in the logs, access denied So give trying for hostname or with full domain or
Grant replication slave on *.* to 'mysqladm'@'95.%' identified by 'xxxxxx'; Grant replication slave on *.* to 'mysqladm'@'hostname identified by 'xxxxxx'; Flush privileges; it should work. Thanks, Dilipkumar Database Engineering mailto: [email protected] Pager mail:[email protected] -----Original Message----- From: Jeetendra Ranjan [mailto:[email protected]] Sent: Thursday, December 24, 2009 2:31 PM To: Shanmugam, Dhandapani; Parikh, Dilip Kumar; [email protected] Subject: Re: Slave is not updated 091223 5:55:22 [Note] Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '/var/lib/mysql/mysql-relay-bin.000001' position: 4 091223 5:55:22 [ERROR] Slave I/O thread: error connecting to master '[email protected]:3306': Error: 'Access denied for user 'root'@'ip-97-74-85-42.ip.secureserver.net' (using password: YES)' errno: 1045 retry-time: 60 retries: 86400 091223 6:55:42 [Note] /usr/sbin/mysqld: Normal shutdown 091223 6:55:42 [Note] Slave I/O thread killed while connecting to master 091223 6:55:42 [Note] Slave I/O thread exiting, read up to log 'FIRST', position 4 091223 6:55:42 [Note] Error reading relay log event: slave SQL thread was killed 091223 6:55:42 InnoDB: Starting shutdown... 091223 6:55:45 InnoDB: Shutdown completed; log sequence number 0 407843552 091223 6:55:45 [Note] /usr/sbin/mysqld: Shutdown complete 091223 6:58:30 [Warning] No argument was provided to --log-bin, and --log-bin-index was not used; so replication may break when this MySQL server acts as a master and has his hostname changed!! Please use '--log-bin=ip-97-74-85-42-bin' to avoid this problem. 091223 6:58:30 InnoDB: Started; log sequence number 0 407843552 091223 6:58:30 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.0.85-community-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition (GPL) 091223 6:58:30 [Note] Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '/var/lib/mysql/mysql-relay-bin.000001' position: 98 091223 6:58:30 [ERROR] Slave I/O thread: error connecting to master '[email protected]:3306': Error: 'Access denied for user 'root'@'ip-97-74-85-42.ip.secureserver.net' (using password: YES)' errno: 1045 retry-time: 60 retries: 86400 091223 7:03:32 [Note] /usr/sbin/mysqld: Normal shutdown 091223 7:03:32 [Note] Slave I/O thread killed while connecting to master 091223 7:03:32 [Note] Slave I/O thread exiting, read up to log 'FIRST', position 4 091223 7:03:32 [Note] Error reading relay log event: slave SQL thread was killed 091223 7:03:32 InnoDB: Starting shutdown... 091223 7:03:33 InnoDB: Shutdown completed; log sequence number 0 407843552 091223 7:03:33 [Note] /usr/sbin/mysqld: Shutdown complete 091223 7:03:38 [Warning] No argument was provided to --log-bin, and --log-bin-index was not used; so replication may break when this MySQL server acts as a master and has his hostname changed!! Please use '--log-bin=ip-97-74-85-42-bin' to avoid this problem. 091223 7:03:38 InnoDB: Started; log sequence number 0 407843552 091223 7:03:38 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.0.85-community-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition (GPL) 091223 7:03:38 [Note] Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '/var/lib/mysql/mysql-relay-bin.000002' position: 98 091223 7:03:38 [ERROR] Slave I/O thread: error connecting to master '[email protected]:3306': Error: 'Access denied for user 'root'@'ip-97-74-85-42.ip.secureserver.net' (using password: YES)' errno: 1045 retry-time: 60 retries: 86400 091223 7:03:44 [Note] /usr/sbin/mysqld: Normal shutdown 091223 7:03:44 [Note] Slave I/O thread killed while connecting to master 091223 7:03:44 [Note] Slave I/O thread exiting, read up to log 'FIRST', position 4 091223 7:03:44 [Note] Error reading relay log event: slave SQL thread was killed 091223 7:03:52 [Warning] No argument was provided to --log-bin, and --log-bin-index was not used; so replication may break when this MySQL server acts as a master and has his hostname changed!! Please use '--log-bin=ip-97-74-85-42-bin' to avoid this problem. 091223 7:03:52 InnoDB: Started; log sequence number 0 407843552 091223 7:03:52 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.0.85-community-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition (GPL) 091223 7:03:52 [Note] Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '/var/lib/mysql/mysql-relay-bin.000003' position: 98 091223 7:03:52 [ERROR] Slave I/O thread: error connecting to master '[email protected]:3306': Error: 'Access denied for user 'root'@'ip-97-74-85-42.ip.secureserver.net' (using password: YES)' errno: 1045 retry-time: 60 retries: 86400 091223 7:04:09 InnoDB: Error: table `horde/horde_sessionhandler` does not exist in the InnoDB internal InnoDB: data dictionary though MySQL is trying to drop it. InnoDB: Have you copied the .frm file of the table to the InnoDB: MySQL database directory from another database? InnoDB: You can look for further help from InnoDB: http://dev.mysql.com/doc/refman/5.0/en/innodb-troubleshooting.html 091223 7:30:52 [ERROR] Slave I/O thread: error connecting to master '[email protected]:3306': Error: 'Lost connection to MySQL server at 'reading initial communication packet', system error: 111' errno: 2013 retry-time: 60 retries: 86400 091223 7:31:52 [ERROR] Slave I/O thread: error connecting to master '[email protected]:3306': Error: 'Access denied for user 'root'@'ip-97-74-85-42.ip.secureserver.net' (using password: YES)' errno: 1045 retry-time: 60 retries: 86400 091223 7:46:14 [Note] Slave I/O thread killed while connecting to master 091223 7:46:14 [Note] Slave I/O thread exiting, read up to log 'FIRST', position 4 091223 7:46:14 [Note] Error reading relay log event: slave SQL thread was killed 091223 7:46:28 [Note] Slave SQL thread initialized, starting replication in log 'ip-208-109-238-76-bin.000041' at position 17907, relay log '/var/lib/mysql/mysql-relay-bin.000001' position: 4 091223 7:46:28 [ERROR] Slave I/O thread: error connecting to master '[email protected]:3306': Error: 'Access denied for user 'root'@'ip-97-74-85-42.ip.secureserver.net' (using password: YES)' errno: 1045 retry-time: 60 retries: 86400 091223 7:47:20 [Note] Slave I/O thread killed while connecting to master 091223 7:47:20 [Note] Slave I/O thread exiting, read up to log 'ip-208-109-238-76-bin.000041', position 17907 091223 7:47:20 [Note] Error reading relay log event: slave SQL thread was killed 091223 7:47:40 [Note] Slave SQL thread initialized, starting replication in log 'ip-208-109-238-76-bin.000041' at position 17906, relay log '/var/lib/mysql/mysql-relay-bin.000001' position: 4 091223 7:47:40 [ERROR] Slave I/O thread: error connecting to master '[email protected]:3306': Error: 'Access denied for user 'root'@'ip-97-74-85-42.ip.secureserver.net' (using password: YES)' errno: 1045 retry-time: 60 retries: 86400 091223 8:07:20 [Note] Slave I/O thread killed while connecting to master 091223 8:07:20 [Note] Slave I/O thread exiting, read up to log 'ip-208-109-238-76-bin.000041', position 17906 091223 8:07:20 [Note] Error reading relay log event: slave SQL thread was killed 091223 8:07:37 [Note] Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '/var/lib/mysql/mysql-relay-bin.000001' position: 4 091223 8:07:37 [ERROR] Slave I/O thread: error connecting to master '[email protected]:3306': Error: 'Access denied for user 'test'@'ip-97-74-85-42.ip.secureserver.net' (using password: YES)' errno: 1045 retry-time: 60 retries: 86400 091223 8:12:59 [Note] Slave I/O thread killed while connecting to master 091223 8:12:59 [Note] Slave I/O thread exiting, read up to log 'FIRST', position 4 091223 8:12:59 [Note] Error reading relay log event: slave SQL thread was killed 091223 8:13:12 [Note] Slave SQL thread initialized, starting replication in log 'ip-208-109-238-76-bin.000041' at position 174925, relay log '/var/lib/mysql/mysql-relay-bin.000001' position: 4 091223 8:13:12 [ERROR] Slave I/O thread: error connecting to master '[email protected]:3306': Error: 'Access denied for user 'root'@'ip-97-74-85-42.ip.secureserver.net' (using password: YES)' errno: 1045 retry-time: 60 retries: 86400 091223 8:15:19 [Note] Slave I/O thread killed while connecting to master 091223 8:15:19 [Note] Slave I/O thread exiting, read up to log 'ip-208-109-238-76-bin.000041', position 174925 091223 8:15:19 [Note] Error reading relay log event: slave SQL thread was killed 091223 23:19:24 [Note] /usr/sbin/mysqld: Normal shutdown 091223 23:19:24 InnoDB: Starting shutdown... 091223 23:19:27 InnoDB: Shutdown completed; log sequence number 0 407845542 091223 23:19:27 [Note] /usr/sbin/mysqld: Shutdown complete 091223 23:20:25 [Warning] No argument was provided to --log-bin, and --log-bin-index was not used; so replication may break when this MySQL server acts as a master and has his hostname changed!! Please use '--log-bin=ip-97-74-85-42-bin' to avoid this problem. 091223 23:20:25 InnoDB: Started; log sequence number 0 407845542 091223 23:20:25 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.0.85-community-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition (GPL) 091223 23:20:31 [Note] /usr/sbin/mysqld: Normal shutdown 091223 23:20:31 InnoDB: Starting shutdown... 091223 23:20:32 InnoDB: Shutdown completed; log sequence number 0 407845542 091223 23:20:32 [Note] /usr/sbin/mysqld: Shutdown complete 091223 23:20:37 [Warning] No argument was provided to --log-bin, and --log-bin-index was not used; so replication may break when this MySQL server acts as a master and has his hostname changed!! Please use '--log-bin=ip-97-74-85-42-bin' to avoid this problem. 091223 23:20:37 InnoDB: Started; log sequence number 0 407845542 091223 23:20:37 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.0.85-community-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition (GPL) 091223 23:55:20 [Warning] Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a slave and has his hostname changed!! Please use '--relay-log=ip-97-74-85-42-relay-bin' to avoid this problem. 091224 0:00:16 [Note] Slave SQL thread initialized, starting replication in log 'ip-208-109-238-76-bin.000042' at position 4436, relay log './ip-97-74-85-42-relay-bin.000001' position: 4 091224 0:00:16 [ERROR] Slave I/O thread: error connecting to master '[email protected]:3306': Error: 'Access denied for user 'root'@'ip-97-74-85-42.ip.secureserver.net' (using password: YES)' errno: 1045 retry-time: 60 retries: 86400 091224 1:04:48 [Note] Slave I/O thread killed while connecting to master 091224 1:04:48 [Note] Slave I/O thread exiting, read up to log 'ip-208-109-238-76-bin.000042', position 4436 091224 1:04:48 [Note] Error reading relay log event: slave SQL thread was killed 091224 1:07:59 [Note] Slave SQL thread initialized, starting replication in log 'ip-208-109-238-76-bin.000042' at position 4702, relay log './ip-97-74-85-42-relay-bin.000001' position: 4 091224 1:07:59 [ERROR] Slave I/O thread: error connecting to master '[email protected]:3306': Error: 'Access denied for user 'root'@'ip-97-74-85-42.ip.secureserver.net' (using password: YES)' errno: 1045 retry-time: 60 retries: 86400 Thanks Jeetendra Ranjan ----- Original Message ----- From: "Shanmugam, Dhandapani" <[email protected]> To: "Jeetendra Ranjan" <[email protected]>; "Parikh, Dilip Kumar" <[email protected]>; <[email protected]> Sent: Thursday, December 24, 2009 2:15 PM Subject: RE: Slave is not updated > > > 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]
