Here is the action i performed:
mysql> GRANT REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO
'xxxxxx'@'xx.xx.xx.xx' IDENTIFIED BY 'xxxxxxxx';
Query OK, 0 rows affected (0.00 sec)
mysql> Flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql> select * from mysql.user where user='adconsent' \G;
*************************** 1. row ***************************
Host: xx.xx.xx.xx
User: xxxxxxx
Password: *02BF3AAD3EDAAD0A1C45A98092B24BDC96172E16
Select_priv: N
Insert_priv: N
Update_priv: N
Delete_priv: N
Create_priv: N
Drop_priv: N
Reload_priv: N
Shutdown_priv: N
Process_priv: N
File_priv: N
Grant_priv: N
References_priv: N
Index_priv: N
Alter_priv: N
Show_db_priv: N
Super_priv: N
Create_tmp_table_priv: N
Lock_tables_priv: N
Execute_priv: N
Repl_slave_priv: Y
Repl_client_priv: Y
Create_view_priv: N
Show_view_priv: N
Create_routine_priv: N
Alter_routine_priv: N
Create_user_priv: N
Event_priv: N
Trigger_priv: N
ssl_type:
ssl_cipher:
x509_issuer:
x509_subject:
max_questions: 0
max_updates: 0
max_connections: 0
max_user_connections: 0
1 row in set (0.00 sec)
mysql> show slave status \G;
*************************** 1. row ***************************
Slave_IO_State: Connecting to master
Master_Host: xx.xx.xx.xx.
Master_User: xxxxx
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: ip-xxx-xxx-xxx-xx-bin.000042
Read_Master_Log_Pos: 7220
Relay_Log_File: ip-xx-xx-xx-xx-relay-bin.000001
Relay_Log_Pos: 98
Relay_Master_Log_File: ip-xxx-xxx-xxx-xx-bin.000042
Slave_IO_Running: No
Slave_SQL_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: 7220
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
Thanks
Jeetendra Ranjan
----- Original Message -----
From: "Shanmugam, Dhandapani" <dhandapani.shanmu...@eds.com>
To: "Parikh, Dilip Kumar" <dilipkumar.par...@eds.com>; "Jeetendra Ranjan"
<jeetendra.ran...@sampatti.com>; <mysql@lists.mysql.com>
Sent: Thursday, December 24, 2009 2:47 PM
Subject: RE: Slave is not updated
by the way did you flush the privileges on the master? What is the
output you get, when you log in as root user on the mysql master server
and issue the below command:
select * from mysql.user where user='replication'\G;
-D
-----Original Message-----
From: Parikh, Dilip Kumar [mailto:dilipkumar.par...@eds.com]
Sent: Thursday, December 24, 2009 2:43 PM
To: Jeetendra Ranjan; mysql@lists.mysql.com
Subject: RE: Slave is not updated
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: dilipkumar.par...@eds.com
Pager mail:9884430...@nma.vodafone.in
-----Original Message-----
From: Jeetendra Ranjan [mailto:jeetendra.ran...@sampatti.com]
Sent: Thursday, December 24, 2009 2:31 PM
To: Shanmugam, Dhandapani; Parikh, Dilip Kumar; mysql@lists.mysql.com
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
'r...@201.107.236.77: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
'r...@201.107.236.77: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
'r...@201.107.236.77: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
'r...@201.107.236.77: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
'r...@201.107.236.77: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
'r...@201.107.236.77: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
'r...@201.107.236.77: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
'r...@201.107.236.77: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
't...@201.107.236.77: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
'r...@201.107.236.77: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
'r...@201.107.236.77: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
'r...@201.107.236.77: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" <dhandapani.shanmu...@eds.com>
To: "Jeetendra Ranjan" <jeetendra.ran...@sampatti.com>; "Parikh, Dilip
Kumar" <dilipkumar.par...@eds.com>; <mysql@lists.mysql.com>
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:jeetendra.ran...@sampatti.com]
Sent: Thursday, December 24, 2009 1:49 PM
To: Parikh, Dilip Kumar; mysql@lists.mysql.com
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" <dilipkumar.par...@eds.com>
To: "Jeetendra Ranjan" <jeetendra.ran...@sampatti.com>;
<mysql@lists.mysql.com>
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:9884430...@nma.vodafone.in
-----Original Message-----
From: Jeetendra Ranjan [mailto:jeetendra.ran...@sampatti.com]
Sent: Thursday, December 24, 2009 1:05 PM
To: mysql@lists.mysql.com
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/mysql?unsub=dhandapani.shanmu...@eds.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/mysql?unsub=dhandapani.shanmu...@eds.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
