MySql

Question

Hi How to create connection to MySql using c# Thanks

Vulpes · Answer

Check out the specimen connection strings on this site: http://www.connectionstrings.com/mysql

Vulpes · Answer

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

Jagjit Saini · Answer

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" ;

Vulpes · Answer

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

Jagjit Saini · Answer

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

Vulpes · Answer

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.

Jagjit Saini · Answer

Hi Which mirror site should be selected. Thanks

Vilas Gite · Answer

Hi! Refer: http://www.c-sharpcorner.com/UploadFile/mahesh/81/ ---------------------------------------------------------------------------- If this reply helps your post…then check " This is correct answer"

Vulpes · Answer

Yes, it is. I'd use one of those provided by MySql itself, say the ADO.NET driver: http://www.mysql.com/products/connector/

Jagjit Saini · Answer

Hi Is MySql connector is necessary for making connection using c#. Thanks

Satyapriya Nayak · Answer

Hi Jagjit, Please refer our recommended articles section. Thanks

MySql

Answers (11)