C#访问mysql

1. install mysql server

2. open tcp port 3306 on Firewall

3. connect mysql on mysql server machine

 -> Execute the command : GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION

-> Execute the command : flush privileges;

4. New C# project -> add Reference MySql.Data.dll

5. Write the codes

           using MySql.Data.MySqlClient;

            string connectionString = "Database='est';Data Source=10.10.10.211;User Id=root;Password=123456";

            try
            {
                MySqlConnection myConnection = new MySqlConnection(connectionString);
                myConnection.Open();
                MySqlCommand myCommand = myConnection.CreateCommand();
                myCommand.CommandText = "select id,name from student";
                MySqlDataReader myDatareader = myCommand.ExecuteReader();
                while (myDatareader.Read())
                {
                    Console.WriteLine(myDatareader.GetInt32(0) + ", " + myDatareader.GetString(1).ToString());
                }
                myDatareader.Close();
                myConnection.Close();
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.Message);
            }
        }