Facebook Twitter Instagram
    TecAdmin
    • Home
    • FeedBack
    • Submit Article
    • About Us
    Facebook Twitter Instagram
    TecAdmin
    You are at:Home»Databases»MySQL»How to Check MySQL Version

    How to Check MySQL Version

    By RahulDecember 14, 20202 Mins ReadUpdated:July 23, 2021

    MySQL is a relational database management system. At the writing time of this tutorial MySQL, 8 is the latest version available. This tutorial helps you to check the MySQL server version running on your system.

    Advertisement
    • Install MySQL on Ubuntu 20.04
    • Install MySQL on Debian 10

    Find Version with mysqld Command

    Use mysqld command with -V option to check MySQL version running on local host system. The below examples can only used for the localhost only.

    mysqld -V 
    
    Output:
    /usr/sbin/mysqld Ver 8.0.25-0ubuntu0.20.04.1 for Linux on x86_64 ((Ubuntu))

    The above result shows that you are running MySQL version 8.0.25 on your local system.

    Using SELECT VERSION Statement

    You can also obtain the version from within the MYSQL shell by typing the SELECT VERSION() statement:

    mysql> SELECT VERSION();
    
    Output:
    +-------------------------+ | VERSION() | +-------------------------+ | 8.0.25-0ubuntu0.20.04.1 | +-------------------------+ 1 row in set (0.00 sec)

    Using SHOW VARIABLES Statement

    You can also find the MySQL version information, which is stored in a variable named version. Type the below statement to view the MySQL server version.

    mysql> SHOW VARIABLES LIKE "%version%";
    

    MySQL check version

    Check MySQL Version During Connecton

    You can also check the MySQL version with a log-in to MySQL command-line interface. When we connect to the MySQL shell, it displays a welcome message including the MySQL version running on the system.

    This method can be used to check MySQL versions running on localhost as well as on the remote hosts.

    mysql -u root -p 
    

    How to Check MySQL Version

    Conclusion

    This tutorial helps you to check the MySQL version running on localhost or a remote host.

    MySQL version
    Share. Facebook Twitter Pinterest LinkedIn Tumblr Email WhatsApp

    Related Posts

    (Resolved) MySQL connection error: certificate verify failed

    How to Connect Python with MySQL Database

    How to Find Tomcat Version

    How to Check Tomcat Version on Linux

    Add A Comment

    Leave A Reply Cancel Reply

    Advertisement
    Recent Posts
    • Error: EACCES: permission denied, scandir (Resolved)
    • How To Install Python 3.11 on Ubuntu 22.04 / 20.04
    • How to Install Python 3.11 on Amazon Linux 2
    • An Introduction to the “./configure” Command: Compiling Source Code in Linux
    • How to Install PHP 8.x on Pop!_OS
    Facebook Twitter Instagram Pinterest
    © 2023 Tecadmin.net. All Rights Reserved | Terms  | Privacy Policy

    Type above and press Enter to search. Press Esc to cancel.