Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
364 views
in Technique[技术] by (71.8m points)

How to connect to a MySQL server using C#?

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

See Question&Answers more detail:os

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Answer

0 votes
by (71.8m points)

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


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...