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
181066
Timothy Graupmann
April 25, 2005 09:42PM
Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
98876
Timothy Graupmann
April 28, 2005 11:38AM
Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
78156
vipin koul
August 16, 2005 09:36AM
Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
72307
jeril d
September 30, 2005 02:34AM
Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
69051
Luis González
July 25, 2005 06:54AM
Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
69944
James A. Sterling III
July 25, 2005 11:20AM
Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
59009
Gerardo Rodríguez
August 17, 2005 08:01AM
Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
78887
girionis chrysaorides
August 25, 2005 06:27AM
Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
32690
N Y
March 06, 2007 09:24PM
Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
20234
Earl John Gallarde
February 15, 2008 01:01AM
Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
15990
sh hj
April 25, 2008 10:21AM
Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
14712
lizhu zhang
May 28, 2008 02:47AM
Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
26895
Don Alexander
September 08, 2005 09:09AM
Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
26551
John Cass
September 12, 2005 04:41PM
Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
21426
jeril d
September 30, 2005 02:28AM
Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
27252
epico saga
November 07, 2005 10:30PM
Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
18956
simon smith
February 17, 2006 09:06AM
Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
16030
Marl Atkins
May 28, 2006 02:27PM
Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
17430
Andrea Marchesini
August 09, 2006 03:54AM
Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
7692
Max Miller
October 15, 2008 08:53AM
Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
12522
Edgar Didie Rosas Caceres
December 14, 2007 08:36AM
Re: #HY000Host 'XXX' is not allowed to connect to this MySQL server
10103
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.