how secure are the mySQL db functions for remote server

[mes123]

If I have my PHP script running on one machine and the database hosted on a remote machine so the communication has to travel the web, how secure is the connection? Is there a way of encrypting it at all?

 

[DRJ478]

Most database servers offer SSL connections. Check with your host if that is available for the respective server.

 

[mes123]

ok, if my service provider has a Secure db server, how do i instruct the mysql db connector to initialize a secure connection?

i'm using something like

$conn = mysql_connect("[URL unfurl="true"]www.myfabsqlserver.co.uk",[/URL] "myusername", "letmein");

mysql_select_db("mydb", $conn);
etc etc

 

[DRJ478]

It appears to me that only mysqli functions (PHP5) support SSL connections to MySQL servers.

 

[KingCrab]

As long as you have the 4.x mysql librarys you should just be able to use:
mysql_connect("value","value","value",CLIENT_SSL);