How to connect to a MySQL server using C#?

Question

I have a C# Application which would access a MySQL server on another computer. I am trying to do it via IP. Here is my Connection String :

result = "server =66.45.233.226; user id=testcampuscrm; password =Daph$5656; database=testcampuscrm; convert zero datetime=true; ";

getting error this

Access denied for user 'testcampuscrm'@'66.45.232.178' (using password: YES)

My code is anther hosting and mysql database anther hostig please help us. Thanks

Answer 1

There is multiple things you have to take into consideration while accessing mysql from another machine some them are -

Assuming you did write correct code

1.Change mysql config (my.ini) to receive packets from all IP

2.Add firewall Exception for port 3306 on machine where Mysql is Hosted

3.User name password is Correct and granted proper privileges.

PS:-Do not share server credentials on public forums