[BLU] Re: MySQl user admin

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

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