MySQL SSL connection

Forum related to the ZDBC API-Layer

Moderators: gto, cipto_kh, EgonHugeist

Post Reply
ManUtdFans
Fresh Boarder
Fresh Boarder
Posts: 23
Joined: 23.06.2010, 05:33

MySQL SSL connection

Post by ManUtdFans »

We are using MySQL5 would like to make the initials connection using SSL.

From doc the example:

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')

I guess the '/' will be replaced with '\' in Windows OS?

Are these three files have to be generated under MySQL using MySQL commands? Cannot generate 'manually' like open the 'certificated' and copy and paste the 'key text part' to create?

One more question it is different from website SSL, eg. https, the browsers do not need a certificate install on browser pc, why?
ManUtdFans
Fresh Boarder
Fresh Boarder
Posts: 23
Joined: 23.06.2010, 05:33

Post by ManUtdFans »

Anyone has any experience or knowledge about these please?
guidoaerts
Senior Boarder
Senior Boarder
Posts: 93
Joined: 01.07.2009, 16:07

Post by guidoaerts »

certificates (.pem files) have to be generated and signed with a program like openssl. essentially it is the same as used with https in browsers, where the certificates are mostly installed together with the application

guido
Post Reply