Then you should see the phpMyAdmin login page: You will be redirected to the PHPMyAdmin login page: Step 1: Open your web browser and type the URL bellow. You can also verify the MySQL version from the PHPMyAdmin interface. PHPMyAdmin is a graphical interface for managing the databases. Threads: 2 Questions: 14 Slow queries: 0 Opens: 132 Flush tables: 3 Open tables: 52 Queries per second avg: 0.013Ĭheck MySQL Version from PHPMyAdmin Interface You should get the following output: mysql Ver 8.0.19 for Linux on x86_64 (MySQL Community Server - GPL) You should get the following output: +-+Īnother alternative option: The STATUS command also displays the information about MySQL version and the server status: | version_comment | MySQL Community Server - GPL |Īlternative option: You can also use the SELECT VERSION() statement inside MySQL shell to display MySQL version information: You should get the following output with, were you can find the MySQL version: +-+-+ Step 2: Next, run the following command to display the MySQL version into mysql prompt: Provide your root password and hit Enter to log in the MySQL shell. Step 1: First, log in to MySQL Shell with the following command: You can also verify the MySQL version by querying the version variables inside the MySQL shell. Type '\c' to clear the current input statement. Other names may be trademarks of their respective Oracle is a registered trademark of Oracle Corporation and/or itsĪffiliates. Server version: 8.0.19 MySQL Community Server - GPLĬopyright (c) 2000, 2020, Oracle and/or its affiliates.
Provide your root password (can be your any database user) and hit Enter to log in to MySQL shell as with version information shown below: Enter password: Option 2: You can also check the MySQL version by login to MySQL Shell: You should get the MySQL version in the following output: mysql Ver 8.0.19 for Linux on x86_64 (MySQL Community Server - GPL) Option 1: Open your terminal interface and run the following command: The simple and easiest way to find the MySQL version installed on your system using the MySQL client command. There are several ways to check the MySQL version in Linux operating systems. In this case, you will need to find out the MySQL version in your server before installing your application.
#CHECK MYSQL VERSION LINUX INSTALL#
For example, if you want to install some application that requires a specific MySQL version.
This will helps you to find which feature is available for your installed MySQL version.
#CHECK MYSQL VERSION LINUX HOW TO#
If you are a database administrator or system administrator, it is essential to know how to check version of MySQL you have installed.
0 kommentar(er)
