[MySQL] 버젼 확인

출처: http://zetawiki.com/wiki/MySQL_%EB%B2%84%EC%A0%84_%ED%99%95%EC%9D%B8

방법 1: mysql[편집]

[root@zetawiki ~]# mysql --version
mysql  Ver 14.12 Distrib 5.0.77, for redhat-linux-gnu (x86_64) using readline 5.1

→ 5.0.77

방법 2: mysql 접속[편집]

[root@zetawiki ~]# mysql -u testuser -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 810996
Server version: 5.0.77 Source distribution
 
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
 
mysql>

방법 3: SQL[편집]

SELECT VERSION();
SHOW VARIABLES LIKE 'version';

mysql> select version();
+-----------+
| version() |
+-----------+
| 5.0.77    | 
+-----------+
1 row in set (0.00 sec)

mysql> SHOW VARIABLES LIKE 'version';
+---------------+--------+
| Variable_name | Value  |
+---------------+--------+
| version       | 5.0.77 |
+---------------+--------+
1 row in set (0.00 sec)

방법 4: yum[편집]

[root@zetawiki ~]# yum list installed mysql*
... (생략)
Installed Packages
mysql.x86_64                                               5.1.47-1.fc11                                        @updates
mysql-devel.x86_64                                         5.1.47-1.fc11                                        @updates
mysql-libs.x86_64                                          5.1.47-1.fc11                                        @updates
mysql-server.x86_64                                        5.1.47-1.fc11                                        @updates

→ 5.1.47

방법 5: rpm[편집]

[root@zetawiki ~]# rpm -qa | grep ^mysql
mysql-5.1.47-1.fc11.x86_64
mysql-libs-5.1.47-1.fc11.x86_64
mysql-server-5.1.47-1.fc11.x86_64
mysql-devel-5.1.47-1.fc11.x86_64

→ 5.1.47

방법 6: mysqladmin[편집]

[root@zetawiki ~]# mysqladmin -uroot -pP@ssw0rd version | grep ^Server
Warning: Using a password on the command line interface can be insecure.
Server version		5.6.17