Connect to MySQL from c#

Question

0.00/5 (No votes)

See more:

PhpMyadmin situated in https://178.250.xxx.xxx/myadmin

C#

private void button1_Click(object sender, EventArgs e)
        {
 
            server = "178.250.xxx.xxx/myadmin";
            database = "test";
            uid = "test";
            password = "password";
            string connectionString;
            connectionString = "SERVER=" + server + ";" + "DATABASE=" +
            database + ";" + "UID=" + uid + ";" + "PASSWORD=" + password + ";";
 
            connection = new MySQLConnection(connectionString);
            connection.Open(); // show error
            MySQLCommand cmd;
            cmd = new MySQLDriverCS.MySQLCommand("select * from Code", connection);
            MessageBox.Show(cmd.CommandText);
            cmd.ExecuteNonQuery();
           
        }

MySQLDriverCS Exception: MySQLDriverCS Error: can't connect.Can't connect to MySQL server on 'localhost' (10061)

Posted 9-Jan-12 7:11am

Radzhab

Updated 9-Jan-12 7:13am

Mehdi Gholam

v2

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)

SvenMe · Answer 1 · 2012-01-09T07:34:00

Solution 1

The only possible error I see might be your server string.
Just pass the ip to the connection without the path.
In case your server isn't listening on the default port (3306), you also should specify it (Port=xyz;)

Best regards

Posted 9-Jan-12 7:34am

SvenMe

Comments

[no name] 9-Jan-12 13:55pm

i use server = "178.250.xxx.xxx" without path too nothing change...
Maybe protocol is https??

SvenMe 9-Jan-12 14:07pm

You're using https to connect to your instance of MySqlAdmin but not to connect to your database server.

The MySql server is running on your local machine or remotely?

[no name] 9-Jan-12 14:26pm

its not local server. I want connect to remote server

SvenMe 9-Jan-12 14:44pm

Strange that your error message says 'localhost'...
Just another question. Did you configure your MySql server to allow TCP connections from hosts other than localhost? I think by default it is not allowed. You could try the following from your computer

telnet SERVERIP 3306

[no name] 9-Jan-12 14:59pm

i test port - it is opened..

SvenMe 9-Jan-12 15:10pm

How did you test the port?

Actually it is not about testing whether the port is open. It is about testing whether mysql doesn't drop your connection to it.

For example.

[output of the server]
> netstat -a | grep mysql
tcp 0 0 dingo:mysql *:* LISTEN

but

[from my computer]
> telnet dingo 3306
Connecting to dingo...Could not open connection to host, on port 3306: Connect failed.

[no name] 9-Jan-12 15:21pm

telnet 178.250.xxx.xxx 3306
GET / HTTP/1.1
Host: www.google.fr
User-Agent: browseas.com telnet (MSIE compatible)
Referer: http://browseas.com/
Connection: Close

? // ()

5.1.50-0.dotdeb.0��Ax[?ghVT��3%Xk4`f_-]o5Y��Got packets out of order

SvenMe 9-Jan-12 15:29pm

Then I'm sorry. Don't have a clue what's your issue then. Hopefully you are lucky and the modified connection string of Mika Wendelius will help you.
Sorry

Cool Smith 11-Sep-16 3:40am

If you are connecting via lan , you must grant the ip address of the connecting pc for example say the ip of the connecting computer is 192.168.1.123, then do this

create user 'root'@'192.168.1.123' identified by 'password';
grant all privileges on *.* to 'root'@'192.168.1.123' with grant option;
flush privileges;

Wendelius · Answer 2 · 2012-01-09T08:43:00

Solution 2

Re-check the connection string using: http://www.connectionstrings.com/mysql[^]

Posted 9-Jan-12 8:43am

Wendelius

Comments

[no name] 9-Jan-12 15:02pm

connection string is valid

Wendelius 9-Jan-12 15:12pm

Based on your error (Can't connect to MySQL server on 'localhost' (10061)) and the info that you're not actually using localhost but remote host it sounds like the connection string is referring to local host.

What if you try the following format:
Server=ipaddress;Port=3306;Database=test;Uid=test;Pwd=password

[no name] 9-Jan-12 15:25pm

server = "178.250.xxx.xxx";
database = "database";
uid = "Login";
password = "Password";
port ="3306";

connectionString = "Server=" + server + ";" + "Port=" +
port + ";" + "Database=" + database + ";" + "Uid=" + uid + ";" + "Pwd=" + password + ";";

[no name] 9-Jan-12 15:26pm

MySQLDriverCS Exception: MySQLDriverCS Error: can't connect.Can't connect to MySQL server on 'localhost' (10061)

SvenMe 9-Jan-12 15:35pm

Hm OK. Now I see your problem.. Your connection string is wrong :P

You're using MySQLDriverCS connector and not the official one. Didn't recognized it till now.

Your connection string should look like this:

Location=myServerAddress;Data Source=myDataBase;User ID=myUsername;Password=myPassword;Port=3306;Extended Properties="""";

[no name] 9-Jan-12 15:45pm

...
string s ="\"\"";

connectionString = "Location=" + server + ";" + "Data Source=" +
database + ";" + "User ID=" + uid + ";" + "Password=" + password + ";" + "Port" + port + ";" + ";Extended Properties=" + s +";";

MySQLDriverCS Exception: MySQLDriverCS Error: can't connect.Access denied for user 'login'@'81.163.xx.xxx' (using password: YES)

81.163.xx.xxx it is my ip

SvenMe 9-Jan-12 15:47pm

Now you ran into the issue I described above. (In case username and password are correct)
Your user login isn't allowed to connect to the database from that IP. You can use PhpMyAdmin to change this restriction.

For example
http://nst.sourceforge.net/nst/docs/faq/ch06s04.html

Wendelius 9-Jan-12 15:51pm

That's also a good link

Wendelius 9-Jan-12 15:51pm

That seems like a reasonable error. First recheck the userid and password and if that isn't the problem, try going through this checklist: http://dev.mysql.com/doc/refman/5.1/en/access-denied.html[^]