Possible Duplicate:
Connecting to MySQL via SSL using PHP
Im new to php and I am not sure how to go about connecting to a database remotely using ssl. Using mysql workbench I am able to just enter the url of the database and the hostname and our password and select use ssl and I am able to connect. How can I do this using php?
After a few preaprations on the mysql server side that are described here you can connect using ssl with the following php code:
$db = mysqlii_init();
$db->ssl_set('server-key.pem','server-cert.pem', 'cacert.pem', NULL, NULL);
$db->real_connct("your.server.net", "test", "testpass", "yourdb");
Or using the old (deprecated) mysql API this cn be done this way:
$link = mysql_connect("your.server.net", "test", "testpass", false, MYSQL_CLIENT_SSL)
if(!$link) {
die (mysql_error()));
}
Note:
Note that MySQL Native Driver does not support SSL before PHP 5.3.3, so calling this function when using MySQL Native Driver will result in an error. MySQL Native Driver is enabled by default on Microsoft Windows from PHP version 5.3 onwards.
depends on what method you are trying to connect to mysql
$db = mysql_connect('your.server','username','pass',false,MYSQL_CLIENT_SSL);
however as of 5.5 mysql_connect is deprecated [the old connector is going away]
$db = mysqli::init();
$db->set_ssl($key,$cert,$ca,$capath,$cipher);
$db->real_connect($host,$username,$passwd,$dbname);
