DOC HOME SITE MAP MAN PAGES GNU INFO SEARCH PRINT BOOK
 

(mysql.info.gz) Secure requirements

Info Catalog (mysql.info.gz) Secure basics (mysql.info.gz) Secure connections (mysql.info.gz) Secure create certs
 
 5.6.7.2 Requirements
 ....................
 
 To use SSL connections between the MySQL server and client programs,
 your system must be able to support OpenSSL and your version of MySQL
 must be 4.0.0 or newer.
 
 To get secure connections to work with MySQL, you must do the following:
 
   1. Install the OpenSSL library. We have tested MySQL with OpenSSL
      0.9.6.  If you need OpenSSL, visit `http://www.openssl.org'.
 
   2. When you configure MySQL, run the `configure' script with the
      `--with-vio' and `--with-openssl' options.
 
   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 
      Upgrading-grant-tables.
 
   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.gz) Secure basics (mysql.info.gz) Secure connections (mysql.info.gz) Secure create certs
automatically generated byinfo2html