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
181057
Timothy Graupmann
April 25, 2005 09:42PM
Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
98870
Timothy Graupmann
April 28, 2005 11:38AM
Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
78152
vipin koul
August 16, 2005 09:36AM
Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
72304
jeril d
September 30, 2005 02:34AM
Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
69048
Luis González
July 25, 2005 06:54AM
Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
69941
James A. Sterling III
July 25, 2005 11:20AM
Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
59006
Gerardo Rodríguez
August 17, 2005 08:01AM
Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
78881
girionis chrysaorides
August 25, 2005 06:27AM
Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
32686
N Y
March 06, 2007 09:24PM
Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
20229
Earl John Gallarde
February 15, 2008 01:01AM
Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
15987
sh hj
April 25, 2008 10:21AM
Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
14708
lizhu zhang
May 28, 2008 02:47AM
Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
26887
Don Alexander
September 08, 2005 09:09AM
Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
26544
John Cass
September 12, 2005 04:41PM
Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
21423
jeril d
September 30, 2005 02:28AM
Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
27247
epico saga
November 07, 2005 10:30PM
Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
18953
simon smith
February 17, 2006 09:06AM
Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
16026
Marl Atkins
May 28, 2006 02:27PM
Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
17425
Andrea Marchesini
August 09, 2006 03:54AM
Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
7688
Max Miller
October 15, 2008 08:53AM
Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
12516
Edgar Didie Rosas Caceres
December 14, 2007 08:36AM
Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
10100
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.