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
180124
Timothy Graupmann
April 25, 2005 09:42PM
Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
98387
Timothy Graupmann
April 28, 2005 11:38AM
Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
77827
vipin koul
August 16, 2005 09:36AM
Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
72028
jeril d
September 30, 2005 02:34AM
Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
68733
Luis González
July 25, 2005 06:54AM
Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
69596
James A. Sterling III
July 25, 2005 11:20AM
Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
58638
Gerardo Rodríguez
August 17, 2005 08:01AM
Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
77874
girionis chrysaorides
August 25, 2005 06:27AM
Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
32436
N Y
March 06, 2007 09:24PM
Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
19901
Earl John Gallarde
February 15, 2008 01:01AM
Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
15721
sh hj
April 25, 2008 10:21AM
Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
14393
lizhu zhang
May 28, 2008 02:47AM
Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
26577
Don Alexander
September 08, 2005 09:09AM
Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
26081
John Cass
September 12, 2005 04:41PM
Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
21099
jeril d
September 30, 2005 02:28AM
Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
26826
epico saga
November 07, 2005 10:30PM
Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
18405
simon smith
February 17, 2006 09:06AM
Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
15630
Marl Atkins
May 28, 2006 02:27PM
Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
17124
Andrea Marchesini
August 09, 2006 03:54AM
Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
7402
Max Miller
October 15, 2008 08:53AM
Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
12233
Edgar Didie Rosas Caceres
December 14, 2007 08:36AM
Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
9761
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.