MySQL Forums
Forum List  »  Newbie

Re: Access denied for user 'ODBC'@'localhost'
Posted by: Colin Gray
Date: November 15, 2008 10:59AM

jose mathew Wrote:
-------------------------------------------------------
> 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 .* 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...


Hi,
when I tried
mysql>GRANT ALL ON mydb.* TO 'ODBC'@'localhost';
to solve this problem I get th error
can't find any matching row in the user table
Anyone got any ideas?
Thanks

Options: ReplyQuote


Subject
Written By
Posted
Re: Access denied for user 'ODBC'@'localhost'
November 15, 2008 10:59AM


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.