MySQL Forums
Forum List  »  Connector/ODBC

ODBC can't connect to server with certain passwords - how to circumvent?
Posted by: Hans Meise
Date: April 01, 2022 07:14AM

We have MySQL 5.7.34 running on a Debian machine, and have installed the newest (at the time of writing this) version of the ODBC x64 driver on a Windows 10 x64 machine (ODBC x64 driver version

We usually implement very long passwords for our database users and identify the users by sha256_password. We have wondered why a certain user couldn't connect from Windows to the databases on the server. It turned out that the problem depended on the password. We have nailed the problem down to the following statement:

If the password contains the string "}´" (without the quotes; that is, a closing curly brace followed by a forward tick), the ODBC connector can't connect to the respective server.

The mysql client program can connect, though, as well as various custom programs. That means that the ODBC x64 connector is faulty.

How can we work around that problem?

Thank you very much in advance!

Steps to reproduce:

- Set up MySQL server 5.7.34 on a Linux machine (but I guess any other 5.7 version shows the same behavior).
- Create a database and a user who has access to that database.
- Assign the following password to the user (without the quotes): "}´"
- Let the user be identified with sha256_password.

- Install MySQL ODBC connector 64-bit on Windows 10 64 bit.
- Create a system DSN which connects to the server and the database created above, using the credentials of the user created above.
- Notably, enter "}´" (without the quotes) into the password field.
- Click "Test".

After clicking "Test", an error dialog appears, stating: "Invalid connection string attribute".

Note that it even doesn't say "Access denied". Obviously, it even doesn't get to the point where access is verified; it seems to give up before that point.

Options: ReplyQuote

Written By
ODBC can't connect to server with certain passwords - how to circumvent?
April 01, 2022 07:14AM

Sorry, only registered users may post in this forum.

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.