Property

MySQLCommunityServer.SSLAuthorityDirectory

---

Warning

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

Description

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.

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.SSLEnabled, MySQLCommunityServer.SSLKey, MySQLCommunityServer.SSLAuthority, MySQLCommunityServer.SSLCertificate, MySQLCommunityServer.SSLCipher