Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

getting eroor during odbc connectivity in mysql 5.6 Expand / Collapse
Posted Sunday, July 14, 2013 2:33 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, August 8, 2013 5:17 AM
Points: 3, Visits: 6
i am getting following error during the odbc connection
please help me

everything i fed correctly in connector odbc

[hy000][mysql][odbc 5.2(a) driver]access denied for user 'root'@'localhost'(using password:yes)
Post #1473352
Posted Monday, July 15, 2013 8:45 PM


Group: General Forum Members
Last Login: Sunday, December 13, 2015 10:08 PM
Points: 15, Visits: 742
At a guess I'd say you are not using the correct password in your ODBC connection for MySQL user 'root'.

In general for security reasons it is not a good idea to use user 'root' for anything apart from admin. Better to create a new user in MySQL for your application and set up an ODBC connection to that new user.

This is a Microsoft SQL Server forum. It would be better to direct your question to a MySQL forum.
Post #1473955
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse