Kiểm tra phiên bản mysql ubuntu
In this quick tutorial, we'll learn how to check the MySQL version of a server. Without a doubt, MySQL is one of the most popular RDBMS (Relational database management system) options available, so you'll find it pretty much everywhere. There can be some pretty staggering differences between MySQL versions, so knowing which version you're working with is important. Learn here how to check the version of MySQL your server is using! Show Let's start with a quick video review of this
subject: Check the MySQL version
From the Command Line
Note: Are you looking to upgrade MySQL on a Liquid Web Core Managed or Fully Managed server? Then contact our support team! If you’re looking for ways to improve the performance of your VPS, check out our blog on Optimizing Your VPS! From the MySQL Client1. When you run the MySQL command client without any flags the version will be displayed. So while logged in via SSH enter:
The server version in this example is 10.1.29-MariaDB MariaDB Server. 2. From within the MySQL client, you can also run the following command for more details:
In this block of text, you'll find additional version details about your installed MySQL software like innodb_version, protocol_version, version_ssl_library, and more. From The PHPMyAdmin InterfaceIf you aren't familiar with running commands through ssh, you may have access to PHPMyAdmin on the server which gives a nice graphical interface for managing the databases. If you have cPanel or Plesk access you should be able to open PHPMyAdmin when logged in to the hosting account. In PHPMyAdmin on the right side, it should have information listen under the "Database server" section and the "Server version" is what shows the MySQL or MariaDB version is running on the server. When standard uptime is not enough, you don’t have to wage war alone. Liquid Web's High-Availability Databases provides the bleeding edge hardware needed for keeping your site online. Does significantly reducing overhead while not having to worry about managing MySQL sounds like a dream come true? Then check out our affordable plans! Introduction It is essential to know which version of MySQL you have installed. Knowing the version number helps to determine if a specific feature is available or compatible with your system. This article provides five options to check your version of MySQL on Linux operating systems. Prerequisites
Check MySQL Version with V CommandThe easiest way to find the MySQL version is with the command:
The command The MySQL client version in the example above is 10.4.5-MariaDB. Note: The command provides the version of the MySQL client utility. The version could be the same as the MySQL server utility if installed on the same system as the server. However, if the client and server utilities are installed on different systems, they might not be the same. How to Find Version Number with mysql CommandThe MySQL command-line client is a simple SQL shell with input editing capabilities. You need to have administrative privileges or use the To access your MySQL client, use the command:
MySQL version data is available automatically once the MySQL client loads. The MySQL client shell offers a lot more options to retrieve detailed information about the version installed. SHOW VARIABLES LIKE StatementNow that you have accessed the MySQL client shell, statements can provide detailed information about your MySQL installation. Keep in mind that all text commands within the MySQL client must end with a semicolon “;” Enter the following command:
The variable that contains MySQL version information is SELECT VERSION StatementIt’s possible to obtain the version from within the MYSQL
client by typing the
This command derives the data from the STATUS CommandThe
The output includes uptime (how long the MySQL server has been running), threads (the number of active threads), and other useful information. This statement provides the most comprehensive overview regarding the status of the MySQL installation and its current version. Conclusion You now know how to use the command line to check your MySQL version. Additionally, if you need to get a more detailed account of your MySQL version, this article explained how to display additional data from within the MySQL client. |