Xojo Documentation Xojo Documentation

Property (As String )

aMySQLCommunityServer.SSLCipher = newStringValue
or
StringValue = aMySQLCommunityServer.SSLCipher

Supported for all project types and targets.

A list of permissible ciphers to use for SSL encryption. This property is ignored if an SSL connection is not made.

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
MessageBox("Connection failed. Error: " + error.Message)
End Try

See Also

MySQLCommunityServer.SSLMode, MySQLCommunityServer.SSLKey, MySQLCommunityServer.SSLAuthority, MySQLCommunityServer.SSLAuthorityDirectory, MySQLCommunityServer.SSLCertificate