In order to create a secure connection via TLS/SSL between MySQL Data Access Components (MyDAC) and MySQL server, you should use the TMySSLIOHandler component. This component is an adapter between a database client and an TLS/SSL client. The secure connection can be used to transfer data through unprotected communication channels, like Internet.
The communication chart between database client and database server with use of TMySSLIOHandler is presented in the following diagram:
Data exchange between TMyConnection and TScSSLClient which plays as an TLS/SSL client is safe because it is carried out by calling methods of TMySSLIOHandler within the single application.
Step-by-step setup of MySSLIOHandler
|•||Place the TMySSLIOHandler component onto the form.|
|•||Select a storage object in the Storage property. More information about storage setup you will find in the SSL client setup topic.|
|•||Specify the server certificate in the CACertName property.|
|•||Specify the client certificate in the CertName property.|
|•||Place the TMyConnection component onto the form and setup it to connect to the MySQL server.|
|•||Assign the TMySSLIOHandler object to the IOHandler property of TMyConnection.|
|•||Connect to MySQL server by setting TMyConnection.Connected to True.|