. Net connection mysql database statement,. netmysql Database

. Net connection mysql database statement,. netmysql Database

In my project, write the Connection database statement in the configuration file:

<Add key = "ConnectionString" value = "Database = 'testdata'; Data Source = 'localhost'; Port = '000000'; User Id = 'root '; password = 'root'; Charset = 'utf8'; TreatTinyAsBoolean = false "/>

Database is the database name, Data Source is the server address of the database, "localhost" represents the local address, port is the mysql database port number user id represents the user name password represents the user password, charset tableThe character set used for connecting requests to the server. Default: none because the database in the project contains Chinese characters, the different character sets of mysql are also different in Chinese and English. Utf8 can be used to prevent Chinese garbled characters.

The base character set of the database is "utf8" and the database sorting rule is "utf8_general_ci ";