Re: Slave is not updated

2009-12-24 Thread Jeetendra Ranjan
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

RE: Slave is not updated

2009-12-24 Thread Shanmugam, Dhandapani
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

Re: Slave is not updated

2009-12-24 Thread Jeetendra Ranjan
; 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

RE: Slave is not updated

2009-12-24 Thread Parikh, Dilip Kumar
@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.01' position: 4 091223 5:55:22 [ERROR] Slave I/O thread: error connecting to master 'r...@201.107.236.77:3306

RE: Slave is not updated

2009-12-24 Thread Shanmugam, Dhandapani
[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

RE: Slave is not updated

2009-12-24 Thread Parikh, Dilip Kumar
; Jeetendra Ranjan; mysql@lists.mysql.com 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

RE: Slave is not updated

2009-12-24 Thread Shanmugam, Dhandapani
Subject: RE: Slave is not updated User is not the replication it is 'root' (or) mysqladm Thanks, Dilipkumar Database Engineering + mailto: dilipkumar.par...@eds.com Pager mail:9884430...@nma.vodafone.in -Original Message- From: Shanmugam, Dhandapani Sent: Thursday, December 24, 2009 2

Re: Slave is not updated

2009-12-24 Thread Jeetendra Ranjan
, 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

Re: Slave is not updated

2009-12-24 Thread Jeetendra Ranjan
, Dilip Kumar; Jeetendra Ranjan; mysql@lists.mysql.com 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

Re: Slave is not updated

2009-12-24 Thread Nagaraj S
, 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

RE: Slave is not updated

2009-12-23 Thread Parikh, Dilip Kumar
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