<!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>
Darren,<BR>
<BR>
If it was a password error I would be either be getting asked for a password or I would get a bad password response.<BR>
<BR>
I not only flushed the privileges but I also restarted mysql.<BR>
<BR>
<BR>
<BR>
On Mon, 2002-11-18 at 14:30, rt-users-request@lists.fsck.com wrote:
<BLOCKQUOTE TYPE=CITE>
<PRE><FONT COLOR="#737373" SIZE="3"><B><I>From:</B> darren chamberlain
<B>To:</B> rt-users@lists.fsck.com
<B>Subject:</B> Re: [rt-users] MySql 'not allowed to connect to host...'
<B>Date:</B> 18 Nov 2002 13:38:37 -0500
* Fred.Purdue <Fred.Purdue@Pobox.com> [2002-11-18 13:34]:
> Unfortunately I seem to have encountered another problem;
>
> 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?
> But wait, you say! That's easy to fix, you need to allow the other
> host to connect to the database! -- Ah, but alas, I have done that.
> Allowed hosts is set to % and allowed db's is also set to %.
If you modified the grant tables with "UPDATE users SET ..." then you
also need to FLUSH PRIVILEGES.
(darren)</I></FONT></PRE>
</BLOCKQUOTE>
<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>
Post proelium, praemium<BR>
<TABLE CELLSPACING="0" CELLPADDING="0" WIDTH="100%">
<TR>
<TD>
<BR>
</TD>
</TR>
</TABLE>
</TD>
</TR>
</TABLE>
<PRE>
</PRE>
</BODY>
</HTML>