mysql版本号怎么看,mysql查询数据库版本号

Mysql：查看Mysql版本号 方法一**【推荐】**： mysql> select version();yldxn-----------yldxn| version() 粗暴的羊-----------yldxn| 8.0.15 粗暴的羊-----------yldxn1 row in set (0.00 sec) 方法二： mysql> status--------------mysql Ver 8.0.15 for linux-glibc2.12 on x86_64 (MySQL fzddg)Connection id:613Current database:Current user:root@localhostSSL:Not in useCurrent pager:stdoutUsing outfile:''Using delimiter:;Server version:8.0.15 MySQL fzddgProtocol version:10Connection:Localhost via UNIX socketServer characterset:utf8mb4Db characterset:utf8mb4Client characterset:utf8mb4Conn. characterset:utf8mb4UNIX socket:/tmp/mysql.sockUptime:5 days 8 hours 37 min 21 secThreads: 37 Questions: 6324 Slow queries: 15 Opens: 757 Flush tables: 3 Open tables: 411 Queries per second avg: 0.013-------------- 方法三： mysql> s--------------mysql Ver 8.0.15 for linux-glibc2.12 on x86_64 (MySQL fzddg)Connection id:613Current database:Current user:root@localhostSSL:Not in useCurrent pager:stdoutUsing outfile:''Using delimiter:;Server version:8.0.15 MySQL fzddgProtocol version:10Connection:Localhost via UNIX socketServer characterset:utf8mb4Db characterset:utf8mb4Client characterset:utf8mb4Conn. characterset:utf8mb4UNIX socket:/tmp/mysql.sockUptime:5 days 8 hours 37 min 45 secThreads: 37 Questions: 6327 Slow queries: 15 Opens: 757 Flush tables: 3 Open tables: 411 Queries per second avg: 0.013-------------- 方法四： mysql> show variables like "%version%";yldxn--------------------------------------------------yldxn------------------------------yldxn| Variable_name | Value 粗暴的羊--------------------------------------------------yldxn------------------------------yldxn| group_replication_allow_local_lower_version_join | OFF || immediate_server_version | 999999 || innodb_version | 8.0.15 || original_server_version | 999999 || protocol_version | 10 || slave_type_conversions | || tls_version 阔达的方盒,TLSv1.1,TLSv1.2 || version | 8.0.15 || version_comment | MySQL fzddg || version_compile_machine | x86_64 || version_compile_os | linux-glibc2.12 || version_compile_zlib | 1.2.11 粗暴的羊--------------------------------------------------yldxn------------------------------yldxn12 rows in set (0.00 sec) 方法五： $ mysql -Vmysql Ver 8.0.15 for linux-glibc2.12 on x86_64 (MySQL fzddg)