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 | Blog | Linux Links | Bling | About BLU

BLU Discuss list archive


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

[BLU] Re: MySQl user admin



On Tue, 13 Jun 2000, Niall Kavanagh wrote:

> As user root:
> 
> GRANT ALL ON <database> TO <user> [IDENTIFIED BY <password>]
> 
> User would be ptest at localhost. This will give ptest full access, you might
> want to restrict ptest to select, insert, update etc. Details in the
> manual.
> 
> Niall

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)

I thought setting up the records in the mysql database took place of GRANT
statements.  In fact, when I tried, I got 
mysql> grant all on ptest to puser identified by 'ppassword';
Query OK, 0 rows affected (0.04 sec)

0 rows affected.

-
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