Error while connnecting to database

Harsha Eadara

Authentication to host 'localhost' for user 'root' using method 'mysql_native_password' failed with message (using password: NO)

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Harish Supekar9y ago
Post your c# code. also web.config code where connection string is define.
0
Harish Supekar9y ago
Hi,
exception message => " I'm getting object reference not set to instance of an object. "

As per my knowlwdge, variable which is used to assign the connection string value is not initialize in your code.
U need to initialize it properly and try again.
0
Rajkiran Swain9y ago
Do the following:

- Check the properties connection..
- Check if the MySQL port is open.
0
Harsha Eadara9y ago
I'm getting object reference not set to instance of an object.
0
Rajkiran Swain9y ago
Maybe your mysql server has not allowed root access without password yet.

Go to your mysql server, and create a new user with a password defined by you. Use that user to login from Visual Studio. This is because using root account to login is generally not common, but if you insist, you will need to find out your default root password and use that.
0

Puneet Kankar9y ago

string connsqlstring = "SERVER=" + server + ";PORT=" + port + ";user=" + user + ";password=" + password + ";database=" + databank; sqlconn = new MySqlConnection(connsqlstring);              sqlconn.Open();