Re: Access denied for user 'ODBC'@'localhost'
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...
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
Re: Access denied for user 'ODBC'@'localhost'
July 17, 2005 10:40PM
November 25, 2005 08:00PM
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