Unable to connect to MySQL DataSource

[ambarishkunte]

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

[ambarishkunte]

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

[amitchandak]

@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

[ambarishkunte]

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

[ambarishkunte · Accepted solution]

Issue Resolved

Solution :

1. Do a Complete installation of connector instead of Typical .

2. Seperate port no with " : " instead of " , "