Sams Teach Yourself MySQL in 21 Days, Second Edition

Making Secure Connections to MySQL

MySQL supports the use of SSL and the X509 standard, allowing you to make an encrypted connection to a MySQL server.

Note

SSL stands for Secure Sockets Layer and is a way of transmitting data across the Internet using an encryption protocol. Any system receiving data via an SSL connection immediately knows whether the data has been tampered with in transit, or whether the data is bona fide.

X509 is a standard that enables a system to ascertain the identity of another system over the Internet with a good level of certainty.

Combining SSL and X509 enables the setting up of ecommerce applications that have a high level of trust, so a system knows who it's talking to and can be sure that the data it's receiving ...