error while connecting to mysql in C# asp.net

Question

I have an error while connecting my project into mysql database so i have added the code bellow to my button to fetch all rows and display it in a gridView

protected void Button1_Click(object sender, EventArgs e)
        {
            MySqlConnection myconn = new MySqlConnection("server=localhost;uid=root;password=;database=y;");
            string strSQL = "select * from welcome";
            myconn.Open();
            MySqlDataAdapter mydata = new MySqlDataAdapter(strSQL, myconn);
            MySqlCommandBuilder cBuilder = new MySqlCommandBuilder(mydata);
            System.Data.DataSet ds = new System.Data.DataSet();
            mydata.Fill(ds);
            GridView1.DataSource = ds;
            GridView1.DataBind();
            myconn.Close();
        }

When running the the app it shows an error in myconn.Open();

An exception of type 'MySql.Data.MySqlClient.MySqlException' occurred in MySql.Data.dll but was not handled in user code

Additional information: The host localhost does not support SSL connections.

and it pointed to myconn.Open();

You probably have an error either in your connection string or in your select statement. Verify that "welcome" is a table in your mysql database (check for case sensitivity). Also make sure that your database name and password are correct. — BobRodes
– BobRodes, Commented Jun 23, 2018 at 15:49

user9936276 · Accepted Answer · 2018-06-23 17:59:57Z

1

change myconn to :

MySqlConnection myconn = new MySqlConnection("server=localhost;uid=root;password=;database=y;sslmode=none");

Make sure that you are adding sslmode=none in myconn

answered Jun 23, 2018 at 17:59

user9936276

Sign up to request clarification or add additional context in comments.

Comments

kAsdh · Accepted Answer · 2018-06-23 16:20:33Z

0

better try with Entity Frame work

Add ADO.NET Entity model,If will ask to connect db and give some name(ex :userentities)
Then, use below code in your coding

userentities context = new userentities();

 protected void Button1_Click(object sender, EventArgs e)
        {
            using (var dbTransactionContext = context.Database.BeginTransaction())
            {
                //then do the operation
            }
        }

It's really easy

or other wise follow these steps 1. add your connection string in web config

 <add name="UserContext" connectionString="server=localhost;User Id=root;password='';database=databasename;convert zero datetime=True" providerName="MySql.Data.MySqlClient" />

Add follow codes in your code

private MySqlConnection con; con = new MySqlConnection(); con.ConnectionString = ConfigurationManager.ConnectionStrings["UserContext"].ConnectionString; con.Open();

edited Jun 23, 2018 at 16:20

answered Jun 23, 2018 at 16:17

kAsdh

3651 gold badge10 silver badges26 bronze badges

5 Comments

kAsdh Over a year ago

connectionString="server=localhost;User Id=root;password='';database=y;convert zero datetime=True" providerName="MySql.Data.MySqlClient"

kAsdh Over a year ago

change your connection string as above and give a try

Mohamed Hassan Yousif Binyousi Over a year ago

I Didn't touched my code , I just added the above code in my webConfig and click run it shows this error(HTTP Error 403.14 - Forbidden The Web server is configured to not list the contents of this directory. Most likely causes: A default document is not configured for the requested URL, and directory browsing is not enabled on the server.)

Mohamed Hassan Yousif Binyousi Over a year ago

I modified the code and i got same errors as on my Post

Mohamed Hassan Yousif Binyousi Over a year ago

i got this error {"The host localhost does not support SSL connections."}

Collectives™ on Stack Overflow

error while connecting to mysql in C# asp.net

2 Answers 2

Comments

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related