ZConnection via SSL

[ManUtdFans]

I have asked the same question got some feedback but cannot complete my question. I am using Windows XP (SP 3) and Delphi 2007.
Got the way to connect to MySQL by setting the properties:

Properties.Strings = (
'MYSQL_SSL=TRUE'
'MYSQL_SSL_CA=D:/mysql/certs/ca-cert.pem'
'MYSQL_SSL_CERT=D:/mysql/certs/client-cert.pem'
'MYSQL_SSL_KEY=D:/mysql/certs/client-key.pem')

This is from documentation.

Can someone explain a bit more to me as I still in the dark on how to set that up.

I assume 'D:/mysql/certs' drive is the local client drive?
If the client pc is using Windows then it should be 'D:\mysql\certs\', and also I can replace with 'C:\Temp\certs\' ?

For thoses 3 files:
D:/mysql/certs/ca-cert.pem
D:/mysql/certs/client-cert.pem
D:/mysql/certs/client-key.pem

I assume the DB administrator/Network Administrator knows how to 'create'/'make' it?
This leads to another question, I had asked him about to create for me and he looks not sure why client pc needs a client cert, he said web browsers do not need a client cert to be installed using SSL (or https).

Thanks in advance

[tintinux]

Hi

Sure, to connect to MYSQL with SSL you need a certificate on the client.

Regards,

Tintinux