# Determining the MySQL version

> Check which MySQL (MariaDB) version your server runs, using cPanel's server information, phpMyAdmin or the command line.

Source: https://helpcenter.ruachost.com/developers/databases/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.