Forum Discussion
Unable to connect to MySQL DataSource
Hi ,
When trying to create a connection on the gateway , I'm getting the below error . The 64 bit MySQL connector is installed & functional . However am able to create an ODBC connection for the MySQL data source. The Gateway Server is also rebooted to see if it helps , but the issue still persist.
Please assist.
Regards,
Ambarish Kunte
Issue Resolved
Solution :1. Do a Complete installation of connector instead of Typical .
2. Seperate port no with " : " instead of " , "
4 Replies
ambarishkunte , Make sure you have latest .net connector
https://dev.mysql.com/downloads/connector/net/
Also make sure Mysql user work based on IP permission, that is correctly enabled
refer: https://www.digitalocean.com/community/tutorials/how-to-allow-remote-access-to-mysql
Hi Amit,
We have 8.0.23 MySQL connector which is quite the latest & installed on Windows Server 2016 . The config file binding the IP address, I was not able to find at the installed connector location.
I'm also successfully able to connect to the Database using the ODBC MySQL Connector.
Regards,
ambarish kunte
Issue Resolved
Solution :1. Do a Complete installation of connector instead of Typical .
2. Seperate port no with " : " instead of " , "
Update : I was able to connect to another MySQL datasource after choosing the "Complete" option during the installation of the connector instead of a "typical" option
As for the MySQL connection in request is still facing issue but this time with an error 'Connection Option' server is duplicated
