Home
/
Database Support
/
How to check the MySQL version?

How to check the MySQL version?

Table of Contents

How to Check MySQL Version via Command Line

To check your MySQL version, access your website via SSH and type mysql -V (uppercase V). This command will display the MySQL version installed on your system. Alternatively, you can check the version in phpMyAdmin under the Database Server section.

  1. Open Command Line:
    • For Windows: Open Command Prompt.
    • For Mac/Linux: Open Terminal.
  2. Connect to your server
  3. Run the Command:
    • Type mysql -V (uppercase V) and press Enter.
  4. View the Version:
    • The MySQL version will be displayed in the output.

 

You can easily check the MySQL version for websites hosted on SiteGround by going to Site Tools > Site > MySQL > phpMyAdmin -> Access phpMyAdmin. Under Database Server section on the right side, find Server Version where the MySQL version is listed.

How to Check MySQL Version via phpMyAdmin

  1. Access phpMyAdmin:
    • Log in to your hosting control panel and navigate to phpMyAdmin.
  2. Find the Version:
    • Under the Database Server section on the right side, find Server Version where the MySQL version is listed.

Detailed Steps for Different Methods

Method 1: Using SSH Shell

  1. Establish SSH Connection:
    • Use an SSH client like PuTTY or your operating system’s built-in command line shell to connect to your server.
  2. Run the Command:
    • Type mysql -V and press Enter.
  3. View the Version:
    • The MySQL version will be displayed in the output.

Method 2: Using MySQL Shell

  1. Log into MySQL Shell:
    • Type mysql -u [your MySQL username] -p and press Enter.
    • Enter your MySQL password when prompted.
  2. Check the Version:
    • The MySQL version will be displayed upon login.
    • Alternatively, run SHOW VARIABLES LIKE '%version%'; to see detailed version information.

Understanding MySQL Version Numbers

  • Major Version: Indicates significant changes and new features.
  • Minor Version: Indicates smaller updates and improvements.
  • Bug-Fix Version: Indicates bug fixes and minor enhancements.
  • Suffix: Indicates the stability level (e.g., dmr for Development Milestone Releases, rc for Release Candidate).

RELATED ARTICLES

Share This Article