How to get MySQL/Apache/PHP versions

You can use these commands on a virtual private server (VPS) or dedicated server running CentOS. Usually, you will use the CentOS for a web hosting server. Many times you want to check the versions of Apache, PHP and MySQL server.

For MySQL:

root@web [/home/admin]# mysql -V
mysql Ver 14.14 Distrib 5.5.29, for Linux (i686) using readline 5.1
root@web [/home/admin]# 

Notice that capital “V” from the first command.

Alternatively you can use:

root@host [/]# mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 273052
Server version: 5.5.28-cll MySQL Community Server (GPL)
Copyright (c) 2000, 2012, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> SHOW VARIABLES LIKE "%version%";
| Variable_name | Value |
| innodb_version | 1.1.8 |
| protocol_version | 10 |
| slave_type_conversions | |
| version | 5.5.28-cll |
| version_comment | MySQL Community Server (GPL) |
| version_compile_machine | i686 |
| version_compile_os | Linux |
7 rows in set (0.00 sec)

root@host [/]#

For PHP use:

root@host [/]# php -v
PHP 5.3.21 (cli) (built: Jan 27 2013 06:28:24)
Copyright (c) 1997-2013 The PHP Group
Zend Engine v2.3.0, Copyright (c) 1998-2013 Zend Technologies
with the ionCube PHP Loader v4.2.2, Copyright (c) 2002-2012, by ionCube Ltd.
root@host [/]#

For Apache use:

root@host [/]# /usr/local/apache/bin/httpd -v
Server version: Apache/2.2.23 (Unix)
Server built: Jan 27 2013 06:23:25
Cpanel::Easy::Apache v3.16.7 rev9999
root@host [/]#

As you can see, this command will also output the Easy Apache version – if the server has cPanel installed.

Leave a Reply