MySQL 버전 확인

MySQL 버전 확인

1 방법 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 방법 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 방법 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 방법 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 방법 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 방법 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

7 같이 보기

8 참고 자료

http://ddoong2.com/3