MySQL SSL connection
Posted: 04.07.2011, 00:49
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?
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?