[BLU] Re: [BLU] Re: MySQl user admin

[david at kramer.ne.mediaone.net (David Kramer)]

On Tue, 13 Jun 2000, Niall Kavanagh wrote:

> On Tue, 13 Jun 2000, David Kramer wrote:
> 
> > On Tue, 13 Jun 2000, Niall Kavanagh wrote:
> > 
> > > As user root:
> > > 
> > > GRANT ALL ON <database> TO <user> [IDENTIFIED BY <password>]
> > > 
> > Unfortunately, that made things worse!  Now puser can't log in at all.
> > 
> > [root at kramer php4]# mysql --user=puser --password                 
> > Enter password: 
> > ERROR 1045: Access denied for user: 'puser at localhost' (Using password: YES)
> >
> 
> hurm...
> 
> As root, can you select * from mysql.user and see if there is indeed a
> user ptest in there?

It looks like after the grant I needed a mysqladmin reload.

Thanks for your help; looks like it
's working now.

-- 

-------------------------------------------------------------------
DDDD   David Kramer                   http://kramer.ne.mediaone.net
DK KD  
DKK D  Every non-key attribute depends on the key, the whole key,
DK KD  and nothing but the key, so help me Codd.
DDDD                                      (Sybase training class)

-
Subcription/unsubscription/info requests: send e-mail with
"subscribe", "unsubscribe", or "info" on the first line of the
message body to discuss-request at blu.org (Subject line is ignored).