Re: Access denied

[Paul DuBois]

At 14:20 -0300 6/13/03, Ronan Lucio wrote:
Mike,

I forgot to say I'm using mysql-3.23.52
The SHOW DATABASES privilege is not relevant until MySQL 4.0.2.

Perhaps, this GRANT option do not work for this version, look:

-----------------------------
mysql> grant show databases to dfn@"%";
ERROR 1064: You have an error in your SQL syntax near 'show 
databases to dfn@"%"' at line 1

mysql> grant show databases on mysql.* dfn@"%";
ERROR 1064: You have an error in your SQL syntax near 'show 
databases on mysql.* dfn@"%"' at line 1
-----------------------------

Looking for the command syntax in the MySQL manual, it allows
the follow options:
-----------------------------
ALL PRIVILEGES      FILE                RELOAD
ALTER               INDEX               SELECT
CREATE              INSERT              SHUTDOWN
DELETE              PROCESS             UPDATE
DROP                REFERENCES          USAGE
-----------------------------
Do you have any idea about what could be wrong?

Thank's again,
Ronan
On Fri, 13 Jun 2003 11:07:24 -0600
"Mike Hillyer" <[EMAIL PROTECTED]> wrote:
 I find the @localhost line redundant if you havd a @"%" line, as the
 wildcard includes localhost.
 I think the syntax is GRANT SHOW DATABASES TO dfn@"%";

 But I personally do not use it.

 Regards,
 Mike Hillyer
 > www.vbmysql.com


--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Are you MySQL certified?  http://www.mysql.com/certification/

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]