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 j...@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 <machiel.richa...@gmail.com> 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 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
