MySQL Forums
Forum List  »  New in 4.1: Subqueries

Advanced Search
New Topic

Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
Posted by: John Cass
Date: September 12, 2005 04:41PM

I've been trying to connect to a MySQL server from a different Linux PC and getting this error.
I think I have cracked it; if I do

root# mysql --host A -p

from host B, I expect to be connected as 'root'@'B', but it doesn't - it connects you as 'root'@'A'.
So you have to have the user at host A in the 'user' table in mysql on host A.

Once I realised that and ran an appropriate GRANT statement it connected ok.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
#HY000Host 'XXX' is not allowed to connect to this MySQL server
180963
Timothy Graupmann
April 25, 2005 09:42PM
Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
98811
Timothy Graupmann
April 28, 2005 11:38AM
Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
78118
vipin koul
August 16, 2005 09:36AM
Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
72275
jeril d
September 30, 2005 02:34AM
Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
69018
Luis González
July 25, 2005 06:54AM
Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
69910
James A. Sterling III
July 25, 2005 11:20AM
Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
58973
Gerardo Rodríguez
August 17, 2005 08:01AM
Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
78799
girionis chrysaorides
August 25, 2005 06:27AM
Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
32658
N Y
March 06, 2007 09:24PM
Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
20206
Earl John Gallarde
February 15, 2008 01:01AM
Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
15966
sh hj
April 25, 2008 10:21AM
Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
14676
lizhu zhang
May 28, 2008 02:47AM
Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
26850
Don Alexander
September 08, 2005 09:09AM
Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
26501
John Cass
September 12, 2005 04:41PM
Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
21389
jeril d
September 30, 2005 02:28AM
Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
27192
epico saga
November 07, 2005 10:30PM
Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
18908
simon smith
February 17, 2006 09:06AM
Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
15990
Marl Atkins
May 28, 2006 02:27PM
Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
17386
Andrea Marchesini
August 09, 2006 03:54AM
Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
7650
Max Miller
October 15, 2008 08:53AM
Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
12491
Edgar Didie Rosas Caceres
December 14, 2007 08:36AM
Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
10065
Ricardo Santos Pereira
June 08, 2009 03:36PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.