MySQL Connector/ODBC not using DSN password

[Jeremy Todd]

Hi,

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.

Regards,
Jeremy