MySQL 버전 확인

MySQL 버전 확인

 

1 #./mysql --version
./mysql  Ver 8.0.18 for Linux on x86_64 (Source distribution)

 

2. mysql>select version();

+-----------+
| version() |
+-----------+
| 8.0.18    |
+-----------+
1 row in set (0.00 sec)

 

3. mysql> SHOW GLOBAL VARIABLES LIKE '%ver%';
+---------------------------------+--------------------------------------+
| Variable_name                   | Value                                |
+---------------------------------+--------------------------------------+
| binlog_gtid_simple_recovery     | ON                                   |
| character_set_server            | utf8                                 |
| collation_server                | utf8_general_ci                      |
| innodb_dedicated_server         | OFF                                  |
| innodb_force_recovery           | 0                                    |
| innodb_ft_server_stopword_table |                                      |
| innodb_version                  | 8.0.18                               |
| log_error_verbosity             | 2                                    |
| master_verify_checksum          | OFF                                  |
| myisam_recover_options          | OFF                                  |
| protocol_version                | 10                                   |
| relay_log_recovery              | OFF                                  |
| server_id                       | 1                                    |
| server_id_bits                  | 32                                   |
| server_uuid                     | 044cfcb0-3417-11ea-8dec-000c29a5cff5 |
| show_create_table_verbosity     | OFF                                  |
| slave_sql_verify_checksum       | ON                                   |
| slave_type_conversions          |                                      |
| tls_version                     | TLSv1,TLSv1.1,TLSv1.2,TLSv1.3        |
| version                         | 8.0.18                               |
| version_comment                 | Source distribution                  |
| version_compile_machine         | x86_64                               |
| version_compile_os              | Linux                                |
| version_compile_zlib            | 1.2.11                               |
+---------------------------------+--------------------------------------+
24 rows in set (0.00 sec)

 

4. 터미널 환경에서 MySQL 에 로그인해보 버전이 표시된다. 

#./mysql -uroot -p
Enter password: 

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 424
Server version: 8.0.18 Source distribution

Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.