Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[ganesh kumar]

Hi Team 

am getting below error while trying to connect mysql database .. please help me in this why am getiing this error..

Details: “MySQL: Unable to connect to any of the specified MySQL hosts.”

——————————
ganesh kumar
Business Analyst
9500990994
——————————

[Martin Frisch]

Hi,

what is the version of your ODBC Driver. I think at must be at least 5.1. 

Best regards,
Martin

——————————
Martin Frisch
BI Developer
Trützschler GmbH & Co. KG
——————————
——————————————-

[ganesh kumar]

Hi

i have installed  “mysql-connector-net-8.0.17”?

——————————
ganesh kumar
Business Analyst
9500990994
——————————
——————————————-

[Hasham Niaz]

Hi !

Please try setting up with my-SQL ODBC driver & see if its able to get you through.

Regards,

——————————
Hasham Bin Niaz
Director Data & Analytics
Karachi, Pakistan
——————————
——————————————-

[Mark Toddy]

In some of the ways, spacing and the order of parameters in the MySql connection string does matters. So, stick to the standard format:

MysqlConn.ConnectionString = "Server=localhost;Port=1234;Database=My_Mysql_Database;Uid=root;Pwd=root;"

If the above connection string fails, try update your c# mysql connection string as shown below (without port variable as well):

MysqlConn.ConnectionString = "Server=localhost;Database=My_Mysql_Database;Uid=root;Pwd=root;"

Or, sometime the problem could be on your windows firewall, make sure your server allow access to all port associated with your mysql database.

——————————
Mark Toddy
Developer
——————————
——————————————-