h-4.2$ mysql -h $endpoint -u $user -P $port -p$password mydb Welcome to the MariaDB monitor. Commands end with ; or \g. Your MySQL connection id is 35 Server version: 5.7.22-log Source distribution Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MySQL [mydb]> STATUS -------------- mysql Ver 15.1 Distrib 5.5.68-MariaDB, for Linux (x86_64) using readline 5.1 Connection id: 35 Current database: mydb Current user: admin@10.0.1.218 SSL: Not in use Current pager: stdout Using outfile: '' Using delimiter: ; Server: MySQL Server version: 5.7.22-log Source distribution Protocol version: 10 Connection: mydb.cin1rcsx20ld.us-west-2.rds.amazonaws.com via TCP/IP Server characterset: latin1 Db characterset: latin1 Client characterset: utf8 Conn. characterset: utf8 TCP port: 3306 Uptime: 2 hours 1 min 13 sec Threads: 2 Questions: 16909 Slow queries: 0 Opens: 371 Flush tables: 1 Open tables: 57 Queries per second avg: 2.324 -------------- |
h-4.2$ mysql -h $endpoint --ssl-ca=rds-combined-ca-bundle.pem --ssl-verify-server-cert -u $user -P $port -p$password mydb Welcome to the MariaDB monitor. Commands end with ; or \g. Your MySQL connection id is 43 Server version: 5.7.22-log Source distribution Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MySQL [mydb]> MySQL [mydb]> STATUS -------------- mysql Ver 15.1 Distrib 5.5.68-MariaDB, for Linux (x86_64) using readline 5.1 Connection id: 43 Current database: mydb Current user: admin@10.0.1.218 SSL: Cipher in use is DHE-RSA-AES256-SHA Current pager: stdout Using outfile: '' Using delimiter: ; Server: MySQL Server version: 5.7.22-log Source distribution Protocol version: 10 Connection: mydb.cin1rcsx20ld.us-west-2.rds.amazonaws.com via TCP/IP Server characterset: latin1 Db characterset: latin1 Client characterset: utf8 Conn. characterset: utf8 TCP port: 3306 Uptime: 2 hours 7 min 19 sec Threads: 2 Questions: 17170 Slow queries: 0 Opens: 372 Flush tables: 1 Open tables: 58 Queries per second avg: 2.247 -------------- MySQL [mydb]> |
'AWS > AWS Database' 카테고리의 다른 글
AWS Aurora 데이터베이스 (0) | 2022.04.13 |
---|---|
db test python (0) | 2022.04.13 |
AWS DB 실습 동영상 (0) | 2022.04.13 |
Amazon RDS 데이터베이스 (0) | 2022.04.12 |
Database 워크로드 요구사항 (0) | 2022.04.12 |