MySQL Forums
Forum List  »  Connector/ODBC

Bug when connecting to mysql via ODBC driver (from Access)
Posted by: Andreas Rose
Date: February 13, 2015 01:46AM

Hello,
we see a strange bug when connecting to MySQL 5.6 from MS Access with latest
ODBC driver (it also happens when using older drivers like 5.1).

Before the correct connecting to the database with the correct user
and the return of the selected data the driver tries to connect
as User 'Admin' to mysql. We see this in an tcpdump from the server and in
wireshark.
Of course such a user doesnt exist.
This also happens agains a MySQL 5.1 database.
The problem with MySQL 5.6 however is that it registers as an connection_error
which raises the counter and when the max_connect_errors limit is reached bans
the host from which we are accessing the database.

looks like this
MySQL Server Greeting proto=10 version=5.6.12-enterprise-commercial-advanced-log
MySQL Login Request user=Admin db=somedatabase
MySQL Response Error 1045
MySQL Server Greeting proto=10 version=5.6.12-enterprise-commercial-advanced-log
MySQL Login Request user=someuser db=somedatabase
MySQL Response OK
MySQL Request Query
MySQL Response OK

Options: ReplyQuote


Subject
Written By
Posted
Bug when connecting to mysql via ODBC driver (from Access)
February 13, 2015 01:46AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.