dot.web

So what is my MySQL database version?

Whether you’re interested to know that your MySQL database has strong Unicode support or you want to verify that the CMS you’re installing is supported by your server. It’s always good to know your MySQL version.

There are many ways to check. In this article I will demonstrate a few. Hopefully, at least one will work for you.

1. PHPMyAdmin

PHPMyAdmin is the most popular administration web tool for MySQL. It is free, and thus installed on most servers that use MySQL. Enquire your hosting service for the web address of PHPMyAdmin installed on your server.

Once you logged into PHPMyAdmin look at the right side of the main page, under either MySQL or Web server. You may see something like this. Look for Server version (under MySQL) or for MySQL client version (under Web server)

MySQL

• Server version: 5.x.x

Web server

• MySQL client version: 5.x.x

2. Use PHP command: phpinfo()

Now if the above did not work because you don’t have PHPMyAdmin installed or don’t have permissions, you can easily do it by uploading a file that contains a PHP command.

You don’t need to know anything about PHP (a scripting language) or to be a programmer. You do need access to FTP to a file.

Open a text-editor, or use Notepad, the internal Windows editor (Start menu -> Run -> Type “Notepad.exe” -> Click OK).
In notepad, type the following code:

<?php
 
phpinfo();
 
?>

Now save this file as phpinfo.php (the file’s name does not matter, but the .php extension is very important)

Then upload this file to your web-server. Make sure you know how to access the file using a web-address. The last step is to go to your website and run the PHP file like this: http://yourdomain.com/phpinfo.php

Notice that you may have to indicate the correct directory where you put your file.

Running this file will expose a lot of information about your server. Look for the mysql section. The version appears under Client API version.

After completing this step, remember to erase the file from your server, as it exposes sensitive information about your server.

3. WordPress plugin – WP-ServerInfo

When you already have WordPress installed, you can easily check the MySQL version on your server by installing the WP-ServerInfo plugin.

A few WordPress plugins can show server information, but not all will show MySQL version. This one will do the job just fine.

After installation, activate the plug-in, go your Dashboard and click on WP-ServerInfo. Look for the value next to MySQL. This is the correct MySQL version installed on your server.

Tags: MySQL | PHP | PHPInfo | PHPMyAdmin

You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.