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.
Regards, Mike Hillyer www.vbmysql.com -----Original Message----- From: Ronan Lucio [mailto:[EMAIL PROTECTED] Sent: Friday, June 13, 2003 8:34 AM To: [EMAIL PROTECTED] Subject: Access denied Hi All, I created a user "dfn" and I granted access to only the database "dfn". Now, if I log as dfn user query for "SHOW DATABASES", mysql returns me the error: ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) Would anybody know what could be wrong? Thank's Ronan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]