mysql odbc connection problem

--001636c5961eb2d5b4047541096b
Content-Type: text/plain; charset=ISO-8859-1

Hi All

We are experiencing some problems when trying to connect to a mysql database
using ODBC.

The settings have been configured and it seems to be getting to the DB but
we getting the following error:

[S1T00][unixODBC][MySQL][ODBC 3.51 Driver]Access denied for user
'root'@'hostname'
(using password: YES)
[ISQL]ERROR: Could not SQLConnect


can some perhaps assist please?

Regards

--001636c5961eb2d5b4047541096b--

RE: mysql odbc connection problem

Make sure you have granted permissions in the db for root to connect from t=
he host you are trying to connect from. Something like....

GRANT priv ON db.table TO 'root'@'hostname' IDENTIFIED BY 'password';

FLUSH PRIVILEGES;

regards

Regards

John Daisley
Mobile +44(0)7812 451238
Email john@butterflysystems.co.uk

Certified MySQL 5 Database Administrator (CMDBA)
Certified MySQL 5 Developer
Cognos BI Developer

-----------------------
Sent from HP IPAQ mobile device.



-----Original Message-----
From: Machiel Richards
Sent: Tuesday, October 06, 2009 10:41 AM
To: mysql@lists.mysql.com
Subject: mysql odbc connection problem

Hi All

We are experiencing some problems when trying to connect to a mysql databas=
e
using ODBC.

The settings have been configured and it seems to be getting to the DB but
we getting the following error:

[S1T00][unixODBC][MySQL][ODBC 3.51 Driver]Access denied for user
'root'@'hostname'
(using password: YES)
[ISQL]ERROR: Could not SQLConnect


can some perhaps assist please?

Regards


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg