Re: Access denied

[Ronan Lucio <suppressed>]

Mike,

On Fri, 13 Jun 2003 08:38:32 -0600
"Mike Hillyer" <suppressed> wrote:

> Did you GRANT SHOW DATABASES to the user? If not then they will not be
> able to use the command. The SHOW DATABASES GRANT clause is a new
> addition.

I'm sorry but I don't have experience with MySQL.

Actually, I installed PhpMyAdmin in an ISP for the clients
manage his/her own database.

So, I created the account with the command:
GRANT ALL PRIVILEGES ON dfn.* TO suppressed IDENFIED BY 'password';
GRANT ALL PRIVILEGES ON dfn.* TO dfn@"%" IDENFIED BY 'password';

Now, when I access PhpMyAdmin with user "dfn", it shows some
errors in the left frame, where should show the client's database (dfn).

If I grant SHOW DATADABES to this user, Will he see all databases
or just the databases that he has permissions?

Thank's
Ronan

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/suppressed