Make sure you have granted permissions in the db for root to connect from the 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@stripped
Certified MySQL 5 Database Administrator (CMDBA)
Certified MySQL 5 Developer
Cognos BI Developer
-----------------------
Sent from HP IPAQ mobile device.
-----Original Message-----
From: Machiel Richards <machiel.richards@stripped>
Sent: Tuesday, October 06, 2009 10:41 AM
To: mysql@stripped
Subject: mysql odbc connection problem
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
