MySQL是一款开源的关系型数据库管理系统,它支持数据库的安装、管理和查询等功能,有时我们需要查看MySQL的版本信息,以便了解MySQL的版本号。MySQL提供了几种方法来查看MySQL的版本信息,下面介绍几种常见的查看MySQL版本的方法。
查看MySQL的版本信息:
1、在MySQL命令行窗口中输入“select version()”命令,可以查看MySQL的版本信息:
mysql> select version();
+-------------------------+
| version() |
+-------------------------+
| 5.7.17-log |
+-------------------------+
1 row in set (0.00 sec)
2、在MySQL命令行窗口中输入“status”命令,可以查看MySQL的版本信息:
mysql> status
--------------
mysql Ver 14.14 Distrib 5.7.17, for Linux (x86_64) using EditLine wrapper
Connection id: 8
Current database:
Current user: root@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 5.7.17-log MySQL Community Server (GPL)
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: latin1
Db characterset: latin1
Client characterset: utf8
Conn. characterset: utf8
UNIX socket: /tmp/mysql.sock
Uptime: 10 min 43 sec
3、在MySQL命令行窗口中输入“select @@version”命令,可以查看MySQL的版本信息:
mysql> select @@version;
+-------------------------+
| @@version |
+-------------------------+
| 5.7.17-log |
+-------------------------+
1 row in set (0.00 sec)
查看MySQL的其他信息:
1、在MySQL命令行窗口中输入“show variables”命令,可以查看MySQL的全局变量:
mysql> show variables;
+---------------------------------+----------------------------------------+
| Variable_name | Value |
+---------------------------------+----------------------------------------+
| auto_increment_increment | 1 |
| auto_increment_offset | 1 |
| autocommit | ON |
| automatic_sp_privileges | ON |
| back_log | 50 |
| basedir | /usr/local/mysql/ |
| binlog_cache_size | 32768 |
| binlog_direct_non_transactional_updates | OFF |
+---------------------------------+----------------------------------------+
2、在MySQL命令行窗口中输入“show status”命令,可以查看MySQL的状态信息:
mysql> show status;
+--------------------------+-------+
| Variable_name | Value |
+--------------------------+-------+
| Aborted_clients | 0 |
| Aborted_connects | 0 |
| Binlog_cache_disk_use | 0 |
| Binlog_cache_use | 0 |
| Binlog_stmt_cache_disk_use | 0 |
| Binlog_stmt_cache_use | 0 |
+--------------------------+-------+
3、在MySQL命令行窗口中输入“show engines”命令,可以查看MySQL支持的存储引擎:
mysql> show engines;
+--------------------+---------+----------------------------------------------------------------+--------------+------+------------+
| Engine | Support | Comment | Transactions | XA | Savepoints |
+--------------------+---------+----------------------------------------------------------------+--------------+------+------------+
| InnoDB | DEFAULT | Supports transactions, row-level locking, and foreign keys | YES | YES | YES |
| MRG_MyISAM | YES | Collection of identical MyISAM tables | NO | NO | NO |
| MEMORY | YES | Hash based, stored in memory, useful for temporary tables | NO | NO | NO |
| BLACKHOLE | YES | /dev/null storage engine (anything you write to it disappears) | NO | NO | NO |
| MyISAM | YES | MyISAM storage engine | NO | NO | NO |
+--------------------+---------+----------------------------------------------------------------+--------------+------+------------+
以上就是查看MySQL的版本信息的几种常见方法,可以根据需要选择合适的方法来查看MySQL的版本信息。