C # MySql database connection tutorial,

C # MySql database connection tutorial,

Preparation: Create a console program. Reference MySql. Data. dll. Declare the namespace using MySql. Data. Client;

Basic Ideas:

1. Create a new MySqlConnection connection (no connection yet)

Five items are required:

Server (Database IP address, which is 127.0.0.1 or localhost)

Account used by the user to connect to the database

Password

Database Name

Port: port number used to connect to the database. The default value is 3306.

2. open the connection MySqlConnection, open ()

3. Remember to Close MySqlConnection. Close () before you use it. Used to release resources. Otherwise, an error may occur.