MySQL 클라이언트 SSL 접속 확인

1 개요[ | ]

MySQL 클라이언트 SSL 접속 확인

다음 쿼리들로 확인 가능하다

SHOW STATUS LIKE 'Ssl_cipher';
SHOW GLOBAL VARIABLES LIKE 'have_%ssl';
STATUS;

2 예시: SSL 접속[ | ]

mysql> SHOW STATUS LIKE 'Ssl_cipher';
+---------------+--------------------+
| Variable_name | Value              |
+---------------+--------------------+
| Ssl_cipher    | DHE-RSA-AES256-SHA |
+---------------+--------------------+
1 row in set (0.00 sec)

mysql> SHOW GLOBAL VARIABLES LIKE 'have_%ssl';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| have_openssl  | YES   |
| have_ssl      | YES   |
+---------------+-------+
2 rows in set (0.00 sec)

mysql> STATUS;
--------------
mysql  Ver 14.14 Distrib 5.7.14, for Linux (x86_64) using  EditLine wrapper

Connection id:		612
Current database:	
Current user:		test@135.79.246.100
SSL:			Cipher in use is DHE-RSA-AES256-SHA
Current pager:		stdout
Using outfile:		''
Using delimiter:	;
Server version:		5.6.32 MySQL Community Server (GPL)
Protocol version:	10
Connection:		135.79.246.80 via TCP/IP
Server characterset:	utf8
Db     characterset:	utf8
Client characterset:	utf8
Conn.  characterset:	utf8
TCP port:		3306
Uptime:			1 day 22 hours 32 min 19 sec

Threads: 1  Questions: 7981  Slow queries: 0  Opens: 184  Flush tables: 1  Open tables: 177  Queries per second avg: 0.047
--------------

3 예시: SSL 접속 아님[ | ]

mysql> SHOW STATUS LIKE 'Ssl_cipher';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| Ssl_cipher    |       |
+---------------+-------+
1 row in set (0.00 sec)

mysql> SHOW GLOBAL VARIABLES LIKE 'have_%ssl';
+---------------+----------+
| Variable_name | Value    |
+---------------+----------+
| have_openssl  | DISABLED |
| have_ssl      | DISABLED |
+---------------+----------+
2 rows in set (0.00 sec)

mysql> STATUS;
--------------
mysql  Ver 14.14 Distrib 5.1.73, for redhat-linux-gnu (x86_64) using readline 5.1

Connection id:		11059
Current database:	
Current user:		testuser@135.79.246.100
SSL:			Not in use
... (생략)

4 같이 보기[ | ]

MySQL 클라이언트 SSL 설정