How to connect to a remote mysql server using C#?

Question

0.00/5 (No votes)

See more:

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

C#

server = "192.168.10.221";
database = "restaurantdb";
uid = "root";
password = "";
string connectionString;
connectionString = "SERVER=" + server + "; PORT = 3306 ;" + "DATABASE=" + database + ";" + "UID=" + uid + ";" + "PASSWORD=" + password + ";";
mycon = new MySqlConnection(connectionString);

I have another computer in which we are in the same network, but when I try to connect to the Mysql I am not able to connect but locally it works...
What do you think ?

What I have tried:

I published my C# application and then launch it in the other computer so that I will try to connect to mysql but nothing works. But I have to mention that when I put the ip adress in the other computer I can have access to wampserver and phpmyadmin ...

Posted 27-Oct-16 1:35am

TatsuSheva

Updated 27-Oct-16 4:07am

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

#realJSOP · Answer 1 · 2016-10-27T02:24:00

Solution 1

Put a try/catch block around your code , and it will tell you exactly what's wrong. My guess is that it's a permissions problem.

Posted 27-Oct-16 2:24am

#realJSOP

TatsuSheva · Answer 2 · 2016-10-27T04:07:00

Solution 2

I got this error...MySql.Data.MySqlClient.MySqlException (0x80004005): Unable to connect to any of the specified MySQL hosts.

Posted 27-Oct-16 4:07am

TatsuSheva

Comments

[no name] 27-Oct-16 10:12am

THIS is the solution to your problem?

TatsuSheva 27-Oct-16 10:20am

No... but I can't write a comment in the solution above

[no name] 27-Oct-16 10:29am

That is exactly why you have the ability to edit your question and improve the content to provide the information that people need to see to help you with your problem.

TatsuSheva 27-Oct-16 10:34am

So, what should I do now ? I am blocked with this issue :/

[no name] 27-Oct-16 12:42pm

Well, if I were you, I would do what I already told you to do. Then I would google your error message and start looking at the same difficulties that others had had doing the exact same thing that you are doing and seeing what they did to fix it. Then I would start actually doing some of those things to see if if fixes my problem.