Hướng dẫn check version mysql workbench

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:

• Using MySQL client (e.g CLI, Query Browser)
• Using MySQL Workbench
• Using MySQL Administrator (free GUI tool)
• Using mysqladmin
• Using phpMyAdmin

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

Using MySQL client (e.g CLI, Query Browser) to check MySQL version:

If you are using a MySQL client e.g. MySQL command line or Query Browser, you can simply execute the following mysql version query.

SELECT version();

OR

SELECT @@version;

Output:

mysql> SELECT @@version;
+------------+
| @@version  |
+------------+
| 5.0.67-log |
+------------+
1 row in set (0.00 sec)

mysql> SELECT VERSION();
+------------+
| VERSION()  |
+------------+
| 5.0.67-log |
+------------+
1 row in set (0.01 sec)

You can also use the STATUS command in MySQL cli tool to find MySQL version number (output truncated)

mysql> SHOW GLOBAL VARIABLES LIKE '%version%';
.
.

mysql> STATUS;
--------------
mysql  Ver 14.12 Distrib 5.0.67, for redhat-linux-gnu (x86_64) using  EditLine wrapper
.
.
--------------

Using MySQL Workbench:

You could also use MySQL Workbench to check the version number for MySQL. Once you are connected to a server using MySQL Workbench, click on Server from main menu and then "Server Status" to view the server status (including version).

Using MySQL Administrator (free GUI tool) to check MySQL version:

OR if you have access to MySQL Administrator and you are connected to the server. Just click on "Server Information" on the left side pane. The version information will be displayed on the right side pane.

Using mysqladmin to check MySQL version:

You can also find the version number using mysqladmin command line tool. mysqladmin will also provide you good information about the server e.g. uptime, open tables etc.. Here is how I ran it on my windows machine.

C:\>mysqladmin -uroot -p -hlocalhost version
Enter password: ********
mysqladmin  Ver 8.42 Distrib 5.1.30, for Win32 on ia32
Copyright 2000-2008 MySQL AB, 2008 Sun Microsystems, Inc.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license

Server version          5.1.30-community
Protocol version        10
Connection              localhost via TCP/IP
TCP port                3306
Uptime:                 4 days 22 hours 54 min 31 sec

Threads: 3  Questions: 1412  Slow queries: 0  Opens: 537  Flush tables: 1  Open
tables: 0  Queries per second avg: 0.3

Using phpMyAdmin:

Click on home icon on the top-left corner of any page or click on "Server:<hostname>" link at the very top. You should see MySQL server's version number on the right side of the page (something like the image below).

Did this tutorial help a little? How about buy me a cup of coffee?

Please feel free to use the comments form below if you have any questions or need more explanation on anything. I do not guarantee a response.

IMPORTANT: You must thoroughy test any instructions on a production-like test environment first before trying anything on production systems. And, make sure it is tested for security, privacy, and safety. See our terms here.

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?
• Different ways how to get your MySQL version
• How to check MySQL version in Windows Terminal
• How to find MySQL version from the command-line client
  • SSH for checking MySQL version
  • MySQL SHOW VARIABLES LIKE query
  • MySQL SELECT VERSION command
  • MySQL STATUS command
• How to check MySQL version in phpMyAdmin
• How to determine MySQL version using dbForge Studio for MySQL
• How to check MySQL version in Workbench
• How to check MySQL version in XAMPP
• How to find MySQL latest version
• How to upgrade MySQL version
• Conclusion

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 

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.

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;

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.

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.

MySQL STATUS Command

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

STATUS; 

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 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.

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.

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.

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

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.

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.

• Author
• Recent Posts

how to check MySQL version, mysql, mysql tools, update MySQL version