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
Subject
Written By
Posted
November 25, 2004 01:48PM
November 25, 2004 04:15PM
November 26, 2004 05:54AM
November 13, 2007 03:06AM
September 17, 2008 04:01AM
November 26, 2004 10:20AM
November 28, 2004 04:38AM
November 29, 2004 08:24PM
December 25, 2004 12:58AM
November 30, 2004 09:48PM
December 02, 2004 11:36AM
December 02, 2004 11:44AM
December 03, 2004 01:57AM
December 06, 2004 11:16AM
December 19, 2004 12:15AM
November 25, 2005 11:30PM
November 26, 2005 03:47AM
November 25, 2005 08:00PM
Re: Access denied for user 'ODBC'@'localhost'
November 15, 2008 10:59AM
September 27, 2005 06:55AM
September 27, 2005 06:57AM
September 19, 2005 10:55AM
November 01, 2005 01:23PM
November 23, 2005 03:42AM
December 12, 2005 10:15AM
December 18, 2007 02:48AM