This article describes how to determine which MySQL version is installed on a server.
There are several ways to determine the MySQL version installed on your server. Use whichever of the following methods you prefer.
To determine the MySQL version using cPanel, follow these steps:
On the Server Information page, locate the MySQL Version row:
To determine the MySQL version using phpMyAdmin, follow these steps:
The phpMyAdmin page appears. In the Database server section appears the MySQL version:
To determine the MySQL version from the command line, follow these steps:
mysql --version
To view more detailed MySQL version information, log in to MySQL using the mysql program, and then type the following query:
SHOW VARIABLES LIKE "%version%";
This shows detailed version information for MySQL, the database engine, the SSL library, and more:
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)
Subscribe to receive weekly cutting edge tips, strategies, and news you need to grow your web business.
No charge. Unsubscribe anytime.
Did you find this article helpful? Then you'll love our support. Experience the A2 Hosting difference today and get a pre-secured, pre-optimized website. Check out our web hosting plans today.
Usamos cookies con el fin de personalizar para usted nuestro sitio Web y analizar el uso de éste. Usted acepta esto haciendo clic en “Acepto” o al continuar usando el sitio Web. Hay más información sobre cookies en nuestra política de privacidad.