MySql

Jagjit Saini

15y2.1kAzure

Hi

How to create connection to MySql using c#

Thanks

11 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vulpes15y ago
Accepted answer
Check out the specimen connection strings on this site:

http://www.connectionstrings.com/mysql
0
Vulpes15y ago
Unless there are no other unblocked ports, port 80 is not a good choice as it's the one used by HTTP.

However, see if it's any better if you replace localhost with 127.0.0.1
0
Jagjit Saini15y ago
Hi

string
It is giving error after giving Port=80 : A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond
How Port number is given , so that it should not give any problem.
Thanks
ConnectionString = "SERVER=localhost;DATABASE=hr_mysql;Port=80;Persist Security Info=False;uid=jagjit@localhost";
0
Vulpes15y ago
I'd make sure that your firewall isn't blocking access to port 3306 which is the default for MySql.

If it is, then you can specify another port which isn't being blocked rather than change the firewall settings
0
Jagjit Saini15y ago
Hi

string ConnectionString = "SERVER=localhost;DATABASE=hr_mysql;uid=root@localhost;password=''";

But it is giving error message Access denied for the user @localhost to database ha

Thanks
0
Vulpes15y ago
I normally choose mirror sites which are close to me, geographically.

As you're in India, I'd choose one of the mirror sites in Asia, say the National Taiwan University.
0
Jagjit Saini15y ago
Hi

Which mirror site should be selected.

Thanks
0
Vilas Gite15y ago
Hi!

Refer: http://www.c-sharpcorner.com/UploadFile/mahesh/81/

----------------------------------------------------------------------------
If this reply helps your post…then check "This is correct answer"
0
Vulpes15y ago
Yes, it is.

I'd use one of those provided by MySql itself, say the ADO.NET driver:

http://www.mysql.com/products/connector/
0
Jagjit Saini15y ago
Hi Is MySql connector is necessary for making connection using c#. Thanks
0
Satyapriya Nayak15y ago
Hi Jagjit,

Please refer our recommended articles section.

Thanks
0