Can someone please tell me what the command would look like to grant access for the root user to a database and table on a remote host.
Thanks in advance -----Original Message----- From: Gleb Paharenko [mailto:[EMAIL PROTECTED] Sent: 27 October 2005 23:12 To: mysql@lists.mysql.com Subject: Re: Slave Problem Hello. Do you have your Slave is still trying to reconnect? If yes, are you sure that you don't have network problems? > I have a script checking for when the replication fails but that does >not include this type problem. Is this a bug in replication or do I >need to update my script to check for this ? Replication fails sometimes. I haven't found similar bug, but if you able perform an upgrade to the latest release. Often it helps. If you want to debug the problem make a research of the binary logs to find out the weird even, which causes Slave to reconnect. See: http://dev.mysql.com/doc/refman/5.0/en/replication-problems.html Marvin Wright wrote: > Hi, > > I found this morning that the slave replication thread seem to have hung. > Below I have pasted in my show slave status, it seems to be stuck trying to > connect to the master. > To fix this I issued a stop slave and start slave, my slave is about 3 weeks > behind now. > > I have a script checking for when the replication fails but that does not > include this type problem. Is this a bug in replication or do I need to > update my script to check for this ? > > I'm running version 4.1.12 on Redhat AS3. > > Many Thanks > > Marvin. > > mysql> show slave status\G > *************************** 1. row *************************** > Slave_IO_State: Reconnecting after a failed master event read > Master_Host: prdmysql01.prd.lastminute.com > Master_User: web > Master_Port: 3306 > Connect_Retry: 60 > Master_Log_File: prdmysql01-bin.000118 > Read_Master_Log_Pos: 15561995 > Relay_Log_File: prdmysql02-relay-bin.000001 > Relay_Log_Pos: 80882143 > Relay_Master_Log_File: prdmysql01-bin.000118 > Slave_IO_Running: Yes > 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: 15561995 > Relay_Log_Space: 80882143 > 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 > 1 row in set (0.00 sec) > > > ********************************************************************** > This email and any files transmitted with it are confidential and > intended solely for the use of the individual or entity to whom they > are addressed. If you have received this email in error please notify > the system manager. > > This footnote also confirms that this email message has been swept by > MIMEsweeper for the presence of computer viruses. > > www.mimesweeper.com > ********************************************************************** > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] Visit our websites: http://www.dailysnack.com “bite size news and gossip” http://www.express.co.uk The Worlds Greatest Newspaper http://www.dailystar.co.uk Simply The Best 7 Days A Week http://www.happymagazine.co.uk The One Stop Shopping Magazine http://www.ok.co.uk First For Celebrity News http://www.northernandshell.co.uk The Mark Of Excellence http://www.expresspictures.com Express Newspapers and OK Magazine online picture archive Also visit: The NMA: Opening Up Newspapers http://www.nmauk.co.uk ###2004### ________________________________________ Any views or opinions are solely those of the author and do not necessarily represent those of Express Newspapers ________________________________________ The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material.If you are not the intended recipient of this message please do not read ,copy, use or disclose this communication and notify the sender immediately. It should be noted that any review, retransmission, dissemination or other use of, or taking action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. E-mail communications may be monitored. **************************************************************************** ##EXN2000## -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
