Determining the MySQL version

Determining the MySQL Version

You can check which version of MySQL is installed on your server using cPanel, phpMyAdmin, or the command line.

Method 1: Using cPanel

1. Log in to your cPanel account.

2. In the right sidebar under General Information, click Server Information.

3. Locate the MySQL Version row to see the installed version.

Method 2: Using phpMyAdmin

1. Log in to phpMyAdmin.

   • If using cPanel, click the phpMyAdmin icon in the Databases section.

2. In the Database server section, the MySQL version is displayed.

Method 3: Using the Command Line

1. Log in to your server via SSH.

2. To see a basic version, run:

mysql --version

3. For detailed version information, log in to MySQL:

mysql -u username -p

Then run the query:

SHOW VARIABLES LIKE "%version%";

This provides detailed information, including the MySQL/MariaDB version, database engine version, SSL library, and more. Sample output:

MariaDB [(none)] SHOW VARIABLES LIKE "%version%";


Variable_name                     Value
──────────────────────────────────────────────────────────────────────────────
in_predicate_conversion_threshold 1000
innodb_version                    10.3.23
protocol_version                  10
slave_type_conversions            
system_versioning_alter_history   ERROR
system_versioning_asof            DEFAULT
version                           10.3.23-MariaDB-cll-lve
version_comment                   MariaDB Server
version_compile_machine           x86_64
version_compile_os                Linux
version_malloc_library            jemalloc 3.6.0-0-g46c0af68bd248b04df75e4f92d5fb804c3d75340
version_source_revision           607467bd63db2c6ca64610eb9f4e703711f4dfc6
version_ssl_library               OpenSSL 1.0.2k-fips 26 Jan 2017
wsrep_patch_version               wsrep_25.24


14 rows in set (0.002 sec)

This method helps you identify the server’s MySQL or MariaDB version for compatibility and troubleshooting purposes.