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=myU sername;Pwd=myPassword;

Specifying port

Server=myServerAddress;Port=1234;Database=myDataBa se;Uid=myUsername;Pwd=myPassword;

Named pipes

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

Multiple Server

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

Using encryption

Server=myServerAddress;Database=myDataBase;Uid=myU sername;Pwd=myPassword;Encryption=true;

or


Server=myServerAddress;Database=myDataBase;Uid=myU sername;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=myU sername;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