(mysql.info) secure-using-openssl

Info Catalog

(mysql.info) secure-basics

(mysql.info) secure-connections

(mysql.info) secure-using-yassl

 
 5.9.7.2 Using SSL Connections with OpenSSL
 ..........................................
 
 To use SSL connections between the MySQL server and client programs,
 your system must support either OpenSSL or (as of MySQL 5.0.10) yaSSL.
 This section covers OpenSSL. To use yaSSL, read 
 secure-using-yassl, instead.
 
 To get secure connections to work with MySQL and OpenSSL, you must do
 the following:
 
   1. Install the OpenSSL library if it has not already been installed.
      We have tested MySQL with OpenSSL 0.9.6. If you need OpenSSL,
      visit `http://www.openssl.org'.
 
   2. When you configure MySQL, invoke the `configure' script with the
      -with-vio and -with-openssl options:
 
           shell> ./configure --with-vio --with-openssl
 
   3. Make sure that you have upgraded your grant tables to include the
      SSL-related columns in the `mysql.user' table. This is necessary if
      your grant tables date from a version prior to MySQL 4.0.0. The
      upgrade procedure is described in  mysql-upgrade.
 
   4. To check whether a running `mysqld' server supports OpenSSL,
      examine the value of the `have_openssl' system variable:
 
           mysql> SHOW VARIABLES LIKE 'have_openssl';
           +---------------+-------+
           | Variable_name | Value |
           +---------------+-------+
           | have_openssl  | YES   |
           +---------------+-------+
 
      If the value is `YES', the server supports OpenSSL connections.
 

Info Catalog

(mysql.info) secure-basics

(mysql.info) secure-connections

(mysql.info) secure-using-yassl