参数 | 说明 | 查询 | 设置 |
max_connect_errors | 账号最大登录次数 | show variables like '%max_connect_errors%' | SET GLOBAL max_connect_errors = 1000; |
have_openssl 和 have_ssl 为yes 时表示开启了 ssl
mysql> show global variables like '%ssl%';
+---------------+----------+
| Variable_name | Value |
+---------------+----------+
| have_openssl | DISABLED |
| have_ssl | DISABLED |
| ssl_ca | |
| ssl_capath | |
| ssl_cert | |
| ssl_cipher | |
| ssl_crl | |
| ssl_crlpath | |
| ssl_key | |
+---------------+----------+