Hosting Questions

[ismail11]

How to check the MySQL version on the server hosting my account?

[mesasa]

You can check the MySQL version using the phpinfo function. To do this, you should create a simple php file (for example phpinfo.php) with the following line in it:

<?php phpinfo(); ?>

Then you should open this file in a browser to see the full Apache/PHP information. The path to the file should be:

yourdomainname.com/phpinfo.php

The MySQL version is shown next to Client API version in the MySQL section of the file.

[yahu123]

Thank you for share!

[jimfaster]

SELECT @@VERSION;

OR

SHOW GLOBAL VARIABLES LIKE '%version%';

The former works even from a query issued via, say, PHP.