MySQL Forums
Forum List  »  Connector/ODBC

MySQL Connector/ODBC not using DSN password
Posted by: Jeremy Todd
Date: August 25, 2021 05:29PM


I'm running macOS 11.5.2 and Excel 16.52 with iODBC 3.52.15 and then finally MySQL Connector/ODBC 8.0.26. I had to relocate the MySQL connector library from /usr/local to /Library/ODBC after installing, so the sandboxed Excel could read it, but otherwise it is working.

My issue is that I need to enter a username and password every time I connect to the database from Excel. With other MySQL connectors I was prompted, but if I just hit OK without entering anything, it would use the "user" and "password" fields from the DSN.

Are there any limitations around embedding a username and password into the DSN? It seems like I'm missing something obvious but I haven't been able to get it to connect without my typing the user/password every time.


Options: ReplyQuote

Written By
MySQL Connector/ODBC not using DSN password
August 25, 2021 05:29PM

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.