Xojo Documentation Xojo Documentation

Property (As FolderItem )

aMySQLCommunityServer.SSLAuthorityDirectory = newFolderItemValue
or
FolderItemValue = aMySQLCommunityServer.SSLAuthorityDirectory

Supported for all project types and targets.

The path to a directory that contains trusted SSL CA certificates in PEM format. 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
Beep
MessageBox("Connection failed. Error: " + error.Message)
End Try

See Also

MySQLCommunityServer.SSLMode, MySQLCommunityServer.SSLKey, MySQLCommunityServer.SSLAuthority, MySQLCommunityServer.SSLCertificate, MySQLCommunityServer.SSLCipher