Boston Linux & Unix (BLU) Home | Calendar | Mail Lists | List Archives | Desktop SIG | Hardware Hacking SIG
Wiki | Flickr | PicasaWeb | Video | Maps & Directions | Installfests | Keysignings
Linux Cafe | Meeting Notes | Linux Links | Bling | About BLU

BLU Discuss list archive


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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



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).




BLU is a member of BostonUserGroups
BLU is a member of BostonUserGroups
We also thank MIT for the use of their facilities.

Valid HTML 4.01! Valid CSS!



Boston Linux & Unix / webmaster@blu.org