Try using [EMAIL PROTECTED] (assuming you're connecting from localhost) to grant permission. I had similar problems and doing that fixed it for me.
Steven:)
Ronan Lucio wrote:
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
-- ++++++++++++++++++ Steven Hong [EMAIL PROTECTED]
CISSP, RHCE, CCNA, SCNA, SCJP, MCSE, MCSD, MCT
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]