Bug #24857 unable to connect to mysql 5.0.27
Submitted: 6 Dec 2006 16:57 Modified: 1 Feb 2008 12:09
Reporter: ryan m Email Updates:
Status: Closed Impact on me:
Category:Connector / ODBC Severity:S1 (Critical)
Version:3.51.12 OS:Any
Assigned to: CPU Architecture:Any

[6 Dec 2006 16:57] ryan m

for the past couple of days im unable to connect from our odbc connection (3.51.12) on our windows server to the linux server running mysql 5.0.27

the error is listed below if i manually create a dsn connection within windows it works fine but if its within the asp.net script it does not work, this used to work fine a few days ago, and nothings changed scriptwise! it is also fine if i connect using a admin tool?

Exception Details: System.Data.Odbc.OdbcException: ERROR [HY000] [MySQL][ODBC 3.51 Driver]Access denied for user 'myhometownuser'@'server88-208-194-96.live-servers.net' (using password: YES)
ERROR [HY000] [MySQL][ODBC 3.51 Driver]Access denied for user 'myhometownuser'@'server88-208-194-96.live-servers.net' (using password: YES)

Source Error: 

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.  

Stack Trace: 

[OdbcException (0x80131937): ERROR [HY000] [MySQL][ODBC 3.51 Driver]Access denied for user 'user'@'liveserver.net' (using password: YES)
ERROR [HY000] [MySQL][ODBC 3.51 Driver]Access denied for user 'user'@'liveserver.net' (using password: YES)]
   System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode) +35
   System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcConnection connection, OdbcConnectionString constr, OdbcEnvironmentHandle environmentHandle) +131
   System.Data.Odbc.OdbcConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject) +98
   System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup) +27
   System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +47
   System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105
   System.Data.Odbc.OdbcConnection.Open() +37
   EcardApp.DBAccess.FillDt(String strQry) +37
   EcardApp.WebForm2.Page_Load(Object sender, EventArgs e) +75
   System.Web.UI.Control.OnLoad(EventArgs e) +99
   System.Web.UI.Control.LoadRecursive() +47
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1061


How to repeat:
add mysql connection string

ie.     <connectionStrings>
        <add name="myhometownConnectionString" connectionString="Driver={MySQL ODBC 3.51 Driver};option=16387;server=***serversip***;user=;password=user;database=myhometown"
            providerName="System.Data.Odbc" />

and error is shown
[7 Dec 2006 7:31] Valeriy Kravchuk
Thank you for a problem report. Please, send the results of:

select user, host from mysql.user;

Are you sure that grants had not changed recently?
[8 Dec 2006 7:01] Valeriy Kravchuk
I need the results of

select user, host from mysql.user;

to check if it is a bug, or your user just has no proper grants. You may have to connect as root user to get this results, or ask your DBA to give them.
[9 Jan 2007 0:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
[24 Jan 2008 9:43] Tonci Grgin
Ryan, sorry. That part is private now. So, what's the status of your problem now? Have you tried new versions of MyODBC?
[1 Feb 2008 12:09] Tonci Grgin
Ryan, I have no rule over your comments, please try it your self...

Closing the report now.