Property

MySQLCommunityServer.SSLMode

---

Warning

This item was deprecated in version 2019r2. Please use MySQLCommunityServer.SSLEnabled as a replacement.

Description

Set to True to enable an SSL connection.

Sample code

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

Compatibility

All project types on all supported operating systems.

See also

MySQLCommunityServer parent class; MySQLCommunityServer.SSLCertificate, MySQLCommunityServer.SSLKey, MySQLCommunityServer.SSLAuthority, MySQLCommunityServer.SSLAuthorityFolder, MySQLCommunityServer.SSLCipher