MySQL 버전 확인

MySQL 버전 확인

1 방법 1: mysql

실행예시 (5.0.77)

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

2 방법 2: mysql 접속

[root@jmnote ~]# mysql -u root -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

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

4 방법 4: yum

[root@jmnote ~]# 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                                        @update

5 방법 5: rpm

[root@jmnote ~]# 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 같이 보기

• 아파치 버전 확인