job.answiz.com
  • 4
Votes
name
name Punditsdkoslkdosdkoskdo

How to check my PHP and MySQL versions in Ubuntu VPS?

HI I am going to install MyBB but I am not sure whether I have installed the correct version of PHP and MySQL.

PHP version 5.1.0 or above with XML Extension installed

MySQL version 4.0 or above

How to check that? Especiall the PHP XML Extension?

Is there simpler way than the <?php phpinfo() ?> solution? I am expecting a command line solution.

Thanks a lot!

In this tutorial I will explain how to check MySQL version number in different ways. MySQL provides some features for particular version numbers and on particular platforms only. So, in some situations it gets really important to find the MySQL version number installed. If you are faced with such a problem you can use any of the following techniques to find MySQL version number.

I am going to show you how to find MySQL version number using the following tools and techniques:

Please note that these techniques will work on most/all platforms (including Windows, Solaris, Linux etc) where MySQL and clients can be installed. This also includes major Linux distributions like Ubuntu, Centos, Debian, Gentoo etc

  • 0
Reply Report

Any one of these queries will tell you what the MySQL version running is once connected:

SELECT VERSION();

SHOW VARIABLES LIKE 'version';

This works for MySQL 5.1+

SELECT variable_value FROM information_schema.global_variables
WHERE variable_name='version';

Doing the following from the command line:

mysql -V will get you the version of the client.

mysqld -V will get you the version of the server.

  • 1
Reply Report