Keyword not supported in connectionString

Question

I'm trying to connect my application with mysql server using localhost. The problem I'm facing is beyond my understanding. I've tried searching it but could not find any solution.

Error showing:

"Keyword not supported: 'uid'";

Below is the code:

Form1.cs

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.SqlClient;
using System.Data.Sql;
using System.Data.CData.MySQL;
using MySql.Data.MySqlClient;



namespace DataAccess
{
    public partial class Form1 : Form
    {

        public Form1()
        {

            InitializeComponent();
        }

        private void label4_Click(object sender, EventArgs e)
        {

        }

        private void button1_Click(object sender, EventArgs e)
        {

            MySQLConnection connection;

            String server = "localhost", database = "Student", userid = "root", password = "12345";
            String connectionString = "SERVER = " + server + ";" + "DATABASE = " + database + ";" + "USERID =" + userid + ";" + "PASSWORD = " + password + ";";

            String std_name = textBox1.Text, std_program = comboBox1.Text, std_department = comboBox2.Text;
            int std_age = Convert.ToInt32(textBox2.Text);
         //   MySQLDataAdapter mda = new MySQLDataAdapter("Insert into student.registration(Name, Age, Program, Department) Values(@std_name,@std_age,@std_program,@std_department)", connection);
            connection = new MySQLConnection(connectionString);
            MySQLCommand cmd;
            connection.Open();

            try
            {
                cmd = connection.CreateCommand();
                cmd.CommandText = "Insert into Student(Name, Age, Program, Department) Values(@std_name,@std_age,@std_program,@std_department)";
                cmd.ExecuteNonQuery();
                MessageBox.Show("Record Successfully Entered!");
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                if (connection.State == ConnectionState.Open)
                {
                    connection.Close();

                }
            }
        }
    }
}

What's the error? Have you granted root user the proper access? Refer to http://stackoverflow.com/questions/8484722/access-denied-for-user-rootlocalhost-while-attempting-to-grant-privileges — Jim Buckley Barret, May 01 '16 at 17:54

score 1 · Answer 1 · answered May 01 '16 at 17:55

1

check your connection string here

https://www.connectionstrings.com/mysql/

a standard way is

Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;

some key are different from yours...

answered May 01 '16 at 17:55

danilonet

1,757
16
33

I've changed my code like your's but still gives the same error. – Mikka May 01 '16 at 18:00
check if your mysql is running, listening to localhost on port 3306 – danilonet May 01 '16 at 18:04
It is running but on port 80. – Mikka May 01 '16 at 18:06
it is really strange... anyway as you can read here https://www.connectionstrings.com/mysql/ you can specify the mysql port if the server is not running on standard port (3306) – danilonet May 01 '16 at 18:09
Oh my bad! Now its running on port 3306, meanwhile downloading a file on every occasion. – Mikka May 01 '16 at 18:10
please add to you post exact error and stack trace, tnx – danilonet May 01 '16 at 18:11
Please re look to my post! I've just mentioned the error – Mikka May 01 '16 at 18:14

Keyword not supported in connectionString

1 Answers1