MySQL Variables ssl_key 数据库 参数变量解释及正确配置使用
本站中文解释
(mysql> set global ssl_key=’/etc/ssl/client-key.pem’);
MySQL的ssl_key参数变量指定客户端使用的SSL私钥。
用法:
set global ssl_key=’/etc/ssl/client-key.pem’;
通过使用该变量,MySQL允许客户端机器可以使用SSL私钥接受SSL连接,这有助于保护数据通过网络传输时的安全。这个变量可以用在命令行,也可以在配置文件中用global或者session(本来会话)配置,设置后立即生效,不用重启服务器。建议将此参数以及SSL加密要求运用到MySQL工作中,保护MySQL的流量安全。
官方英文解释
ssl_key
Command-Line Format | --ssl-key=file_name |
---|---|
System Variable | ssl_key |
Scope | Global |
Dynamic | No |
Type | File name |
Default Value | NULL |
The path name of the server SSL private key file in PEM
format. For better security, use a certificate with an RSA key
size of at least 2048 bits.
If the key file is protected by a passphrase, the server
prompts the user for the passphrase. The password must be
given interactively; it cannot be stored in a file. If the
passphrase is incorrect, the program continues as if it could
not read the key.