Check Your Current MySQL Version in 6 Ways

December 28th, 2021

MySQL is an extremely popular open-source RDMS, and it’s widely used by millions of companies and professionals. In this article, you will learn how to check the current MySQL version, and how to update it if necessary.

Contents

Why do you need to know your MySQL version?

In some situations, it is critical to know what the current MySQL version is as particular features might not be compatible with your system. Also, the installation of the best MySQL version reduces the risks of your system collapsing. Getting a new version also means new features and better capability for your system. Now, let’s see how we can check if your MySQL server has already the latest version and how to upgrade it if it’s not.

Different ways how to get your MySQL version

Now that you know why it is important to keep your version of the database up-to-date, you might ask how to get the newest MySQL version. The good news is, it’s not that difficult. We’ll offer you several ways and provide queries to check your current version. So this is how you can get your MySQL version:

  • From the command line
  • Using your MySQL Client
  • From the phpMyAdmin interface
  • With the help of dbForge Studio for MySQL
  • Using Workbench
  • Via XAMPP

How to check MySQL version in Windows Terminal

One of the easiest ways to check the version of your local MySQL server from the command line on Windows is by using the following command, which works not only on Windows, but also on MAC, Linux, and Ubuntu:

mysql -V 

Check MySQL version terminal in Windows

How to find MySQL version from the command-line client

Just open your MySQL client, and the information about your current MySQL version will be available straight away.

How to check MySQL version in MySQL client from command line

There is also a bunch of other ways to find out the MySQL server version from the command line:

  • Using SSH
  • With the help of the SHOW VARIABLES LIKE query
  • Using the SELECT VERSION command
  • With MySQL STATUS command

Let’s take a closer look at each way of checking the MySQL version.

SSH for checking MySQL version

You can easily use Secure Shell for checking your MySQL version. Log in to the server via SSH and enter the following command to get the information about your current version:

select @@version;
SSH for check MySQL version

MySQL SHOW VARIABLES LIKE query

Another way to show the MySQL version information is with the help of a SHOW VARIABLES LIKE statement. In MySQL Command Line Client, enter the following command:

SHOW VARIABLES LIKE 'version';

The MySQL version will be shown instantly.

Query to show MySQL version, information

MySQL SELECT VERSION command

MySQL Client allows getting the version info by running the SELECT VERSION() command in the MySQL database. Here is the syntax for MySQL SELECT VERSION query:

SELECT VERSION();

Don’t forget to use semicolons as a statement delimiter when working with MySQL Client.

Select version in MySQL database

MySQL STATUS Command

You can also view your current MySQL version with the STATUS command:

STATUS; 
View status in the command line

The output includes the version comment information that helps check your MySQL version status, such as uptime, threads, and much more.

How to check MySQL version in phpMyAdmin

If you feel like getting MySQL version information by running commands from the command line is not your cup of tea, you might try checking the current MySQL version in phpMyAdmin. It provides a convenient user-friendly interface for database management. If you want to know your MySQL version in phpMyAdmin, have a look at the information listed under the  Database Server section. You will find the MySQL version there and will be able to update it if necessary.

How to know MySQL version in phpMyAdmin

How to determine MySQL version using dbForge Studio for MySQL

dbForge Studio for MySQL is one of the best tools for database management, administration, and development. You can quickly and easily check the current MySQL version when working in the dbForge MySQL GUI tool. In fact, there are two ways to do this.

dbForge Studio for MySQL - best MySQL GUI tool

First, you get information about the MySQL server version when customizing connection settings. In the Database Connection Properties window, enter connection settings, and click Test Connection.

In case you need to find out your MySQL version after you’ve connected, right-click the connection name in Database Explorer and select Properties.

View MySQL server version in dbForge Studio for MySQL

To learn more about how to connect to MySQL server remotely, please refer to our blog post.

How to check MySQL Version in Workbench

If you want to know how to check the MySQL version in Workbench, we’ll provide you with a few simple steps. First, open Workbench and choose your database server in the main menu, then click Server Status. All the information regarding your version history is listed in this window. This is how you can check if you have the latest MySQL version and update it if it’s old.

MySQL version control in MySQL Workbench

How to check MySQL Version in XAMPP

To check MySQL version in XAMPP, open Windows Command Prompt, navigate to the folder where XAMPP is installed, and run the following command:

mysql -V
How to know MySQL version in XAMPP

Another way to check your current MySQL version in XAMPP is as follows. Navigate to the readme_en.txt file which can be found in your XAMPP installation folder. There, you will see the MySQL version number.

XAMPP version check

How to find MySQL latest version

After you have found out your MySQL version, you inevitably have a question: what is the latest version of MySQL? The current latest stable version of MySQL is 8.0. 

To ensure that your database is running on the latest MySQL version, you can follow the MSQL community, where you can download the new version from the latest version list. The MySQL version history is really rich, and every new release gives more space for users to work faster and more efficiently.

How to upgrade MySQL version

After having checked your current MySQL version, you might discover that it isn’t the latest one. In this case, you’ll need to upgrade your MySQL version following our simple instructions.

If you have later versions of MySQL, that might save your time because they get auto-updated. In this case, you don’t need to do anything. If you are determined to take the process under your control and do everything manually, you can follow our simple instructions. Before starting, don’t forget to backup your MySQL database to be sure your data is safe.

1. Upgrade your MySQL version using the command line just like you did while checking the current MySQL version.

mysql_upgrade -u root -p –force

2. Upgrading your MySQL version using cPanel provides you with deeper root access, as it comes with Web Host Manager. To upgrade your current MySQL version, access WHM and navigate to Software > MySQL Upgrade. Select the MySQL version you’d like to upgrade and click Next.

3. To upgrade the MySQL version on Linux/Ubuntu, use your SSH credentials, and in the MySQL APT Repository, run the following command:

sudo apt-get update

The package list will be updated. Then upgrade MySQL using either

sudo apt-get upgrade mysql-server

or

sudo apt-get install mysql-server

3. If you need to upgrade the MySQL version on MacOS, you might notice that the upgrade process is quite similar to the one on Linux as it uses Secure Shell. You will also need a package manager, e.g. Homebrew. To upgrade your MySQL version on MacOS, log in to the Terminal program using your SSH credentials. After that, launch Homebrew and run the following command:

brew update
brew install mysql

This will install MySQL 8.0

If you experience problems while upgrading MySQL and to avoid version mismatch, try uninstalling the old version first by executing the following command:

brew remove mysql
brew cleanup

When the process of upgrade is over, test your system by running this command:

mysql.server start

4. If you are intending to upgrade the MySQL version on Windows, note that it’s impossible to use SSH by default here. However, you can choose PuTTY, an SSH and telnet client, to input your SSH credentials. Other steps are similar to the ones you performed for upgrading MySQL on Linux/Ubuntu.

Alternatively, you can use MySQL Installer. In this case, you don’t need the SSH connection.

Conclusion

In this article, we have a detailed guide on how to check your MySQL version in 6 simple ways. These instructions can be of great use for all users who work with MySQL and want their database management system to be most efficient and relevant. We have also discussed several ways of how to upgrade your MySQL on different operating systems.

We invite you to test-drive one of the best MySQL admin tools on the market—dbForge Studio for MySQL. It is a universal all-in-one tool that incorporates all the essential tools needed for effective database development, management, and administration. Download a fully functional 30-day trial from our website and evaluate all the advanced features the Studio delivers.

Comments are closed.