How to use MySql datatbase in ASP.NET using C#

Question

I am using MySql database in ASP .NET using C#. When I am trying to connect to any of the databases of MySql it's giving exception of "Access denied for user root@localhost (using password NO)"

Connection string : MySqlConnection con = new MySqlConnection(@"server=localhost;User Id=root;database=sample"); I am using root with password...still it's saying NO Password

Please post your code and connection string. – mason Feb 19 '14 at 05:57 — mason, Feb 19 '14 at 05:57
is it localhost or remote connection – apesa Feb 19 '14 at 06:00 — apesa, Feb 19 '14 at 06:00
@apesa, either way it should work – Christian Mark Feb 19 '14 at 06:22 — Christian Mark, Feb 19 '14 at 06:22

score 1 · Answer 1 · edited May 23 '17 at 12:03

Since connecting seems to be the crux of your problem, be sure to use a connection string in the form:

string server = "XXX";
string database = "XXX";
string uid = "XXX";
string password = "XXX";
string connectionString =
    "Server=" + server + ";" +
    "Database=" + database + ";" +
    "Uid=" + uid + ";" +
    "Password=" + password + ";";

I've answered another question about using MySQL from C# that may be of further help by providing a little more context.

Also, be sure to print out or inspect connectionString with your debugger if you still have trouble. Sometimes an error like you're seeing comes down to a simple flub that only becomes clear when you look at the full connection string you've built...and find that it is not what you expected.

Finally, be sure to test with a MySQL client too if trouble connecting persists. As with looking at the connection string you've built to find a simple mistake, sometimes a credentials test outside of your code with a trusted client will reveal that the credentials...truly do not work like you expected.

I did same but it doesn't work – user3326597 Feb 20 '14 at 04:48 — user3326597, Feb 20 '14 at 04:48

How to use MySql datatbase in ASP.NET using C#

1 Answers1