<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
<META NAME="GENERATOR" CONTENT="GtkHTML/1.1.6">
</HEAD>
<BODY>
<BR>
<BR>
On Mon, 2002-11-18 at 23:08, Bruce Campbell wrote:
<BLOCKQUOTE TYPE=CITE>
<PRE><FONT COLOR="#737373" SIZE="3"><I>[ Firstly, if you're getting the list in digest form, please make sure
that you change the subject line to be relevant, and not that of the
digest number. This helps people following archives and doing
subject-based sorting ]</I></FONT></PRE>
</BLOCKQUOTE>
<FONT SIZE="3"><TT>Sorry - I normally do but I was in a hurry and forgot to change the subject back. :-[</TT></FONT>
<BLOCKQUOTE TYPE=CITE>
<PRE><FONT COLOR="#737373" SIZE="3"><I>On 18 Nov 2002, Fred.Purdue wrote:
> > From: darren chamberlain
> > * Fred.Purdue <Fred.Purdue@Pobox.com> [2002-11-18 13:34]:
> > > shell> mysql -h helpdesk.corp.newoppinc.org -u root
> > > ERROR 1130: Host 'helpdesk.corp.newoppinc.org' is not allowed to
> > > connect to this MySQL server
> >
> > No password?
>
> If it was a password error I would be either be getting asked for a
> password or I would get a bad password response.
Depending on which varient of the mysql client you have, you should get
either 'blah blah is not allowed' or 'Access is denied for blah (using
password: NO)'.
Try snarfing the rt mysql username and password out of the config.pm file
and specifying them directly, eg:
$ mysql -u rt_user -p rt_pass -h db.host rt2
( 'rt_pass' can be absent, and MySQL will prompt you )
The MySQL access controls also limit by database requested, although if
you are connecting as the mysql root user (and failing), then you probably
have more serious problems.
You could also try connecting to 'localhost' instead of 'helpdesk.blah'.
> I not only flushed the privileges but I also restarted mysql.
Then you have mysql root (admin) access.</I></FONT></PRE>
</BLOCKQUOTE>
<BLOCKQUOTE>
<FONT SIZE="3"><TT>[root@helpdesk fpurdue]# mysql -u rt_user -h helpdesk rt2 -ppassword<BR>
<BR>
ERROR 1130: Host 'helpdesk.corp.newoppinc.org' is not allowed to connect to this MySQL server<BR>
<BR>
[root@helpdesk fpurdue]# mysql -u rt_user -h localhost rt2 -ppassword<BR>
<BR>
Reading table information for completion of table and column names<BR>
You can turn off this feature to get a quicker startup with -A<BR>
<BR>
Welcome to the MySQL monitor. Commands end with ; or \g.<BR>
[...etc]</FONT>
</BLOCKQUOTE>
The problem isn't being able to connect to mysql from the localhost, the problem is connecting over the network...<BR>
</TT><BR>
<TABLE CELLSPACING="0" CELLPADDING="0" WIDTH="100%">
<TR>
<TD>
-- <BR>
Fred.Purdue <<A HREF="mailto:Fred.Purdue@Pobox.com">Fred.Purdue@Pobox.com</A>><BR>
<BR>
Consultants Calling: Remember - If you're not part of the solution, there's money to made in prolonging the problem
</TD>
</TR>
</TABLE>
<PRE></PRE>
</BODY>
</HTML>