MySQL ¹ØÓÚOpenSSLÖ¤ÊéÖ§³Ö¼ì²é·½Ê½

1¡¢mysql±àÒë²ÎÊý£º
#cat /usr/local/mysql/bin/mysqlbug|grep configure
# This is set by configure
CONFIGURE_LINE="./configure '--prefix=/usr/local/mysql' '--with-openssl' '--enable-thread-safe-client' '--enable-local-infile' '--with-charset=gbk' '-with-extra-charsets=gb2312,gbk'"
±íʾ±àÒëÖÐÖ§³Öopenssl;
2.¼ì²éMYÅäÖÃÎļþ£º
 #find / -name my.cnf|xargs cat|grep ssl
½á¹ûÈçÏ£º
ssl-ca=/usr/local/mysql/var/ca-cert.pem
ssl-cert=/usr/local/mysql/var/server-cert.pem
ssl-key=/usr/local/mysql/var/server-key.pem
±íʾÓÐÖ§³Ö¡£
3.¼ì²émysqlÊý¾Ý¿âÊÇ·ñÆôÓÃopenssl
3.1 ²»½øÈëÊý¾Ý¿â·½Ê½
#/usr/local/mysql/bin/mysqladmin -uroot -p VARIABLES | grep -i ssl
  | have_openssl                    |   YES                                   |
±íʾopensslÆôÓÃ
3.2 ½øÈëÊý¾Ý¿â·½Ê½
mysql> SHOW VARIABLES LIKE '%ssl%';     
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| have_openssl  | YES   |
±íʾopensslÆôÓÃ
4. ¼ì²éÊý¾Ý¿â°æ±¾
4.1 Íⲿ¼ì²é
    4.1.1 #mysql -V
    4.1.2 #mysql --help | grep Distrib
4.2 ÄÚ²¿¼ì²é
    4.2.1
mysql> status;
     4.2.2
select version();
 ÁíÍâ×ÊÁÏ£º
 http://blog.csdn.net/hy2003fly/archive/2006/12/31/1471261.aspx
1¡¢nginx±àÒë²ÎÊý£º
#/usr/local/nginx/sbin/nginx -V
2¡¢apache±àÒë²ÎÊý£º
# cat /usr/local/apache/build/config.nice
3¡¢php±àÒë²ÎÊý£º
# /usr/local/php/bin/php -i |grep configure
4¡¢mysql±àÒë²ÎÊý£º
# cat /usr/local/mysql/bin/mysqlbug|grep configure