I installed My SQL 9.2.0 in my local. Also, I am able to connect to MySQL databases using using terminal.
Also, I installed MySQL ODBC Connector version 9.2.0 too in my local.
I tried creating a DSN for the local MySQL database in my local. I am getting the below issue when I use the connection string with DSN name:
Error: System.Data.Odbc.OdbcException: ERROR [01000] [unixODBC][Driver Manager]Can't open lib 'MySQL ODBC 9.2 ANSI Driver' : file not found