标题: 请问各位大侠，要实现MYSQL加密传输，应该怎么做？ [打印本页] 作者: lmclmc000 时间: 2006-01-05 14:22 标题: 请问各位大侠，要实现MYSQL加密传输，应该怎么做？ MYSQL加密传输应该怎么实现，有如下的操作步骤：
To get secure connections to work with MySQL, you must do the following:
Install the OpenSSL library. We have tested MySQL with OpenSSL 0.9.6. If you need OpenSSL, visit http://www.openssl.org.
When you configure MySQL, run the configure script with the --with-vio and --with-openssl options.
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 Section 2.10.3, “Upgrading the Grant Tables”.
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.