mysql5.5开启ssl_mysql5.5等版本如何启用SSL

第一步，查看mysql是否支持SSL

mysql> show variables like '%ssl%';

如果出现以下结果表示支持，如果没有考虑更换版本，或者编译一个带有SSL版本的mysql

+---------------+----------------------------------+

| Variable_name | Value                            |

+---------------+----------------------------------+

| have_openssl  | YES                              |

| have_ssl      | YES                              |

第二步，生成证书

# Generate a CA key and certificate with SHA1 digest

openssl genrsa 2048 > ca-key.pem

openssl req -sha1 -new -x509 -nodes -days 3650 -key ca-key.pem > ca-cert.pem

# Create server key and certficate with SHA1 digest, sign it and convert

# the RSA key from PKCS #8 (OpenSSL 1.0 and newer) to the old PKCS #1 format

openssl req -sha1 -newkey rsa:2048 -days 730 -nodes -keyout server-key.pem > serv