MySQL Forums
Forum List  »  Newbie

Re: Access denied for user 'ODBC'@'localhost'
Posted by: jose mathew
Date: July 17, 2005 10:40PM

The problem is that u ie: the ODBC user has no right to access the system from local host..

to solve it just go to mysql prompt and type;

mysql>GRANT ALL ON <your database name>.* TO 'ODBC'@'localhost';

eg:

mysql>GRANT ALL ON mydb.* TO 'ODBC'@'localhost';

where mydb is the name of the database;


if it is not possible to login using :
c:>mysql -uroot -p mysql
Password:********* (the password you have given when u installed mysql)


also try with out a password if it is not working..
To perform "GRANT..." u should be root.


have a nice day..n..enjoy programming...

Options: ReplyQuote


Subject
Written By
Posted
Re: Access denied for user 'ODBC'@'localhost'
July 17, 2005 10:40PM


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.