How to connect to my sql server remotly(Using IP Address)

Question

0.00/5 (No votes)

See more:

Hi,

I am using mysql for db, am trying to connect mysql remotly using IP address,
please help me how to connect to mysql remotly using c# and am using windows7 os.

XML

<add name="MySqlConnection" connectionString="Data Source=localhost;Initial Catalog=DbName;Username=Username;Password=1234;Pooling=false;Max Pool Size=500;Min Pool Size=1;"
      providerName="MySql.Data.MySqlClient" />

This is my connection string for connectiong for mysql db. inpalce of "Data Source=localhost" i want to give IP address.
i tried giving ip address but it is not connecting, it is giving erros as "

C#

Unable to connect to any of the specified MySQL hosts

".

Posted 30-Aug-12 19:40pm

NaveenWin

Updated 30-Aug-12 20:10pm

v2

Add a Solution

Comments

Zoltán Zörgő 31-Aug-12 2:01am

what have you tried so far? Any error message? Since in theory it is just a matter of connection string and driver" installation...

NaveenWin 31-Aug-12 2:07am

<add name="MySqlConnection" connectionstring="Data Source=localhost;Initial Catalog=DbName;Username=Username;Password=1234;Pooling=false;Max Pool Size=500;Min Pool Size=1;"
="" providername="MySql.Data.MySqlClient">

This is my connection string for connectiong for mysql db. inpalce of "Data Source=localhost" i want to give IP address.
i tried giving ip address but it is not connecting, it is giving erros as unable to connect mysql server.

Zoltán Zörgő 31-Aug-12 2:11am

Ok , but are you sure that your provider has left open the tcp ports for the MySQL server? Or both the application and the database server are on the same intranet, without any firewall between?

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)

Sunny_Kumar_ · Answer 1 · 2012-08-30T20:15:00

Solution 1

Hi there,

As you have stated that you're to using MySQL server, use try using this format of connection string:

C#

ConnectionString="server=192.168.1.1;database=test;uid=test;password=test;pooling=false;";

Replace "192.168.1.1" with your actual MySQL server IP address.

Hope this helps.

Happy Coding!

Posted 30-Aug-12 20:15pm

Sunny_Kumar_

Updated 30-Aug-12 20:16pm

v2

Oshtri Deka · Answer 2 · 2012-08-30T23:58:00

Solution 2

I hope this will help.

Posted 30-Aug-12 23:58pm

Oshtri Deka