MySQL Forums
Forum List  »  PHP

Re: Access denied for user 'ODBC'@'localhost' (using password: NO)
Posted by: Jeffrey Wittig
Date: August 05, 2007 08:24PM

Make sure that you have given access rights to user 'ODBC'. Something like

GRANT FULL PRIVILEGES ON *.* TO 'odbc@localhost' IDENTIFIED BY 'yourPassword' WITH GRANT OPTION;

This would give a user 'odbc' access to all your databases with full rights. To check what user and the grants for that user on your system:

SHOW GRANTS FOR 'odbc@localhost';

Options: ReplyQuote


Subject
Written By
Posted
Re: Access denied for user 'ODBC'@'localhost' (using password: NO)
August 05, 2007 08:24PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.