How is it possible to access mysql database being used in website (PHP) to C# window application

Question

0.00/5 (No votes)

See more:

I have created a window application with c# and a website with PHP.

I want to use the same database in both applications.

Website is properly running (Hosted with Linux Server obviously).

I am unable to use the same database in C# window application.

When I try to connection through C#, I get the error...

Access denied for user 'user'@'localhost' (using password: YES)

What I have tried:

MySqlConnection con = new MySqlConnection("Server=localhost; Database=database_name; User=user; Password=password");

//The same configuration is running on website.

Posted 26-Jul-16 0:22am

Bhola Ram Sahu

Updated 26-Jul-16 3:22am

Add a Solution

Comments

ZurdoDev 26-Jul-16 8:20am

All you have to do is get the connection string right. That should be very simple.

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)

pravinchopade · Answer 1 · 2016-07-26T02:07:00

Solution 1

Try using IP address instead of localhost and mention Port number.

C#

MySqlConnection con = new MySqlConnection(
"Server=127.0.0.1;Port=3306;Database=database_name;Uid=user;Pwd=password;");

Posted 26-Jul-16 2:07am

pravinchopade

Updated 26-Jul-16 2:08am

v2

Richard Deeming · Answer 2 · 2016-07-26T03:22:00

The name "localhost" means "this computer".

Your PHP code is running on a Linux server. The MySQL database is running on the same Linux server, so using "localhost" in your PHP connection string is fine.

Your C# application is (presumably) not running on that Linux server. It's most likely running on a Windows computer. If you ask that code to connect to the MySQL database on the same computer as the C# application, it either won't work, or it won't be connected to the same database instance.

You need to update your C# connection string to specify the correct computer name or IP address of the Linux server which is hosting the database. You might also need to configure the MySQL instance on the Linux box to allow connections from other computers.