MySQL Connector/Net

[pureIso]

Type: .NET Framework Class Library
Usage: MySql.Data.MySqlClient.MySqlConnection
Manufacturer: MySQL

Standard - Default port is 3306

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

Specifying port

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

Named pipes

Server=myServerAddress;Port=-1;Database=myDataBase;Uid=myUsername;Pwd=myPassword;

Multiple Server

Server=serverAddress1 & serverAddress2 & etc..;Database=myDataBase;Uid=myUsername;Pwd=myPassword;

Using encryption

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

or

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

Sample Code

Imports MySql.Data.MySqlClient ' database

Private mySqlConnection As New MySqlConnection
    Private myAdaptor As New MySqlDataAdapter
    Private command As New MySqlCommand

 'connection - FINISHED
    Public Sub MyySQLConnection()

        Try
            mySqlConnection.ConnectionString = "Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;"
            command.Connection = mySqlConnection
            myAdaptor.SelectCommand = command
            mySqlConnection.Open()
        Catch ex As MySqlException
            MessageBoxEx.Show("No Remote or Local MySQL server connection." & Environment.NewLine & ex.Message, "Offline!", MessageBoxButtons.OK, MessageBoxIcon.Information)
        Finally

            mySqlConnection.Dispose()
            mySqlConnection.Close()
        End Try

    End Sub