gdorbes
gdorbes

Reputation: 171

How to keep privacy between a MySQL server and a PHP server

Imagine an architecture composed of 2 Virtual Machines VM1 and VM2 hosted somewhere in the cloud:

It means that there is traffic between VM1 and VM2 composed of queries/results. As this traffic occurs in a VM hosting farm out of my control, I guess that somebody can be a "man-in-the-middle" to analyze this traffic.

My question : In this context, how to guarantee the security/privacy/integrity of the MySQL transactions between VM1 and VM2?

As far as I know, there is no privacy option in mysqli_connect.

Thanks for your help

::Guillaume::

Upvotes: 0

Views: 124

Answers (1)

nunespascal
nunespascal

Reputation: 17724

Use an ssl connection to the mysql server.

You can do this in mysql using the mysqli_ssl_set.

You will have to configure your mysql server to accept ssl connections too.

Refer: PHP to MySQL SSL Connections

Upvotes: 1

Related Questions