mysql- c# connection doesn't complete

Question

I have a MVC project. I added MySql.data.dll file to my project. My localhost and mysql database is open. My database's name is proje and table is hasta_bilgileri.

I searched and tried too many solution but everytime I had different problems. What is the problem with my code? One of the last errors was

"Access denied for user root"

MySqlConnection con = new MySqlConnection("Server=localhost;Database=proje;Uid=root;password=123456;");
MySqlDataAdapter da = new MySqlDataAdapter("Select *From hasta_bilgileri", con);
DataSet table = new DataSet();
try
{
    con.Open();
}
catch (Exception e)
{
    Console.WriteLine(e);
}
da.Fill(table, "hasta_bilgileri");
con.Close();

What output do you get here and what do you expect? Are you getting errors? If so, what are they? We need more details. — DavidG, Jun 27 '18 at 14:48
In your query shouldn’t there be space after * like”Select * from tablename” — Mohsin Mehmood, Jun 27 '18 at 14:51
Why you catch an exception at `con.Open` but not at `da.Fill`? — Tim Schmelter, Jun 27 '18 at 14:52
https://dba.stackexchange.com/questions/30768/access-denied-for-user-root — Tim Schmelter, Jun 27 '18 at 14:54
check if user id and password are correct and try to connect to MySql using this credentials directly. — Jinto Jacob, Jun 27 '18 at 15:08
This is my controller file and I reach it by "localhost:1911/Bolum/hello". Maybe the problem is that? @TimSchmelter public class BolumController : Controller { public void Hello() { void grid() { -HERE THE CODE- } grid(); } } — Hüseyin Argun, Jun 27 '18 at 15:08

score 0 · Accepted Answer · 2018-06-28T09:46:27.447

0

It is not because of your script:

Check the password in con! If it's correct:
In phpmyadmin , in "User Accounts" create a new user!
Make sure you are defining the "Host Name" as "%"!
Declare a clear password that you can use it later in con
Check Global Privileges!

Check here!

Done!

& more about your script:

catch(Exception e) is better to be like this: catch(MySqlException e).
Use Finally after catch exception for closing the connection!

edited Jun 28 '18 at 09:46

answered Jun 28 '18 at 09:40

First of all, thank you for your answer. I did your advices and now there is no warning in my code. Now, the problem is I don't show my data (which came from database) in the page. I asked a new question about that. https://stackoverflow.com/questions/51099082/how-can-we-use-the-data-which-came-from-database-in-c-sharp Can you look and answer it? Thank you so much.. – Hüseyin Argun Jun 29 '18 at 09:57

mysql- c# connection doesn't complete

1 Answers1