File DSN connecting MS Access to MySql database

[briant107]

I have difficulty to create File DSN (.dsn) which allows me use it as ODBC connection to MySQL database to MS Access program.
Driver for MySQL installed and system DSN works, no problem but Access 2019 does not like system DSN,so my hope is for File DSN.
How File DSN looks( with all parameters)?

 

[Jon]

Welcome to the forums! We are the most active Microsoft Access community on the internet by far, with posts going back over 20 years!

To get started, I highly recommend you read the post below. It contains important information for all new users to this forum.

https://www.access-programmers.co.uk/forums/threads/new-member-read-me-first.223250/

We look forward to having you around here, learning stuff and having fun!

 

[theDBguy]

Hi. Welcome to AWF!

I have moved your post out of the Introduction Forum!

 

[theDBguy]

Hi. See if this procedure helps...

MySQL :: MySQL Connector/ODBC Developer Guide :: 5.3.1 Configuring a Connector/ODBC DSN on Windows with the ODBC Data Source Administrator GUI

dev.mysql.com