6.2 Creating a Connector/Net Connection String

6.2.1 Opening a Connection
6.2.2 Handling Connection Errors
6.2.3 Using GetSchema on a Connection

The MySqlConnection object is configured using a connection string. A connection string contains several key/value pairs, separated by semicolons. In each key/value pair, the option name and its corresponding value are joined by an equal sign. For the list of option names to use in the connection string, see Chapter 7, Connector/Net Connection String Options Reference.

The following is a sample connection string:

Server=127.0.0.1;Uid=root;Pwd=12345;Database=test;

In this example, the MySqlConnection object is configured to connect to a MySQL server at 127.0.0.1, with a user name of root and a password of 12345. The default database for all statements will be the test database.

Note

Using the '@' symbol for parameters is now the preferred approach, although the old pattern of using '?' is still supported. To avoid conflicts when using the '@' symbol in combination with user variables, see the Allow User Variables connection string option in Chapter 7, Connector/Net Connection String Options Reference. The Old Syntax connection string option has now been deprecated.