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
180201
Timothy Graupmann
April 25, 2005 09:42PM
Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
98411
Timothy Graupmann
April 28, 2005 11:38AM
Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
77853
vipin koul
August 16, 2005 09:36AM
Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
72053
jeril d
September 30, 2005 02:34AM
Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
68761
Luis González
July 25, 2005 06:54AM
Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
69619
James A. Sterling III
July 25, 2005 11:20AM
Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
58692
Gerardo Rodríguez
August 17, 2005 08:01AM
Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
77934
girionis chrysaorides
August 25, 2005 06:27AM
Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
32462
N Y
March 06, 2007 09:24PM
Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
19958
Earl John Gallarde
February 15, 2008 01:01AM
Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
15749
sh hj
April 25, 2008 10:21AM
Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
14418
lizhu zhang
May 28, 2008 02:47AM
Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
26614
Don Alexander
September 08, 2005 09:09AM
Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
26118
John Cass
September 12, 2005 04:41PM
Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
21123
jeril d
September 30, 2005 02:28AM
Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
26860
epico saga
November 07, 2005 10:30PM
Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
18500
simon smith
February 17, 2006 09:06AM
Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
15664
Marl Atkins
May 28, 2006 02:27PM
Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
17152
Andrea Marchesini
August 09, 2006 03:54AM
Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
7429
Max Miller
October 15, 2008 08:53AM
Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
12254
Edgar Didie Rosas Caceres
December 14, 2007 08:36AM
Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
9792
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.