MySQLCommunityServer.SSLMode

From Xojo Documentation

Revision as of 18:46, 12 November 2019 by PLefebvre (talk | contribs) (Example)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Property (As Boolean )
aMySQLCommunityServer.SSLMode = newBooleanValue
or
BooleanValue = aMySQLCommunityServer.SSLMode

Supported for all project types and targets.

Set to True to enable an SSL connection.

Example

You can securely connect to MySQL using the SSLMode and associated properties:

Var db As New MySQLCommunityServer
db.Host = "192.168.1.172"
db.Port = 3306
db.DatabaseName = "BaseballLeague"
db.UserName = "broberts"
db.Password = "streborb"
db.SSLEnabled = True

// Specify SSL key file
db.SSLKey = New FolderItem("MySQLKeyFile")

// Specify SSL certificate file
db.SSLCertificate = New FolderItem("MySQLCertificateFile")

// Specify SSL authority file
db.SSLAuthority = New FolderItem("MySQLAuthFileFile")

// Specify SSL authority directory
db.SSLAuthorityFolder = New FolderItem("SSLCACertFile")

// Specify SSL cipher
Var cipher As String
cipher = "DHE-RSA-AES256-SHA"
db.SSLCipher = cipher

Try
db.Connect
Catch error As DatabaseException
Beep
MessageBox("Connection failed. Error: " + error.Message)
End Try

See Also

MySQLCommunityServer.SSLCertificate, MySQLCommunityServer.SSLKey, MySQLCommunityServer.SSLAuthority, MySQLCommunityServer.SSLAuthorityDirectory, MySQLCommunityServer.SSLCipher