[Fwd: Re: [rt-users] MySql 'not allowed to connect to host...']

[Fred.Purdue]

On Mon, 2002-11-18 at 23:08, Bruce Campbell wrote: 

> [ 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 ]

Sorry - I normally do but I was in a hurry and forgot to change the
subject back. :-[

> On 18 Nov 2002, Fred.Purdue wrote:
> 
> > > From: darren chamberlain
> > > * Fred.Purdue <Fred.Purdue at 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.
> 
        [root at helpdesk fpurdue]# mysql -u rt_user -h helpdesk rt2
        -ppassword
        
        ERROR 1130: Host 'helpdesk.corp.newoppinc.org' is not allowed to
        connect to this MySQL server
        
        [root at helpdesk fpurdue]# mysql -u rt_user -h localhost rt2
        -ppassword
        
        Reading table information for completion of table and column
        names
        You can turn off this feature to get a quicker startup with -A
        
        Welcome to the MySQL monitor.  Commands end with ; or \g.
        [...etc]

The problem isn't being able to connect to mysql from the localhost, the
problem is connecting over the network...

-- 
Fred.Purdue <Fred.Purdue at Pobox.com>

Consultants Calling: Remember - If you're not part of the solution,
there's money to made in prolonging the problem


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20021119/56c86e19/attachment.htm>