How can I find my MariaDB - MySQL version?

There are several ways to check your MariaDB/MySQL version on Ultra Web Hosting, from phpMyAdmin to the command line. Knowing your version is useful when checking application compatibility, troubleshooting issues, or reporting to a developer.

01. Via phpMyAdmin

1. Log in to cPanel
2. Click phpMyAdmin under the Databases section
3. Look at the right panel on the home page
4. Find "Database server" - the version string is displayed there (e.g., "10.6.18-MariaDB-cll-lve")

02. Via cPanel

cPanel displays the MySQL/MariaDB version in the "Server Information" page:

1. Log in to cPanel
2. Scroll to the bottom of the left sidebar and find "Server Information"
3. Look for "MySQL Version" in the list

03. Via SSH Command Line

If you have SSH access, run any of these:

# Quick version check
mysql -V

# Example output:
# mysql  Ver 15.1 Distrib 10.6.18-MariaDB, for Linux (x86_64)

# Or connect to the database and check
mysql -u cpaneluser_dbuser -p -e "SELECT VERSION();"

# MariaDB-specific version info
mysql -u cpaneluser_dbuser -p -e "SHOW VARIABLES LIKE 'version%';"

The SHOW VARIABLES query returns the version, version comment (e.g., "MariaDB Server"), and version compile information.

04. Via PHP Script

Create a temporary PHP file to check the version programmatically:

<?php
echo 'PHP: ' . phpversion() . '<br>';
echo 'MySQL client: ' . mysqli_get_client_info() . '<br>';

$conn = new mysqli('localhost', 'cpaneluser_dbuser', 'password', 'cpaneluser_dbname');
if (!$conn->connect_error) {
    echo 'Server version: ' . $conn->server_info;
    $conn->close();
}
?>

05. Version Compatibility Notes

Ultra Web Hosting shared servers run MariaDB, which is a drop-in replacement for MySQL. MariaDB versions map to MySQL compatibility levels:

MariaDB 10.3-10.6 - Compatible with MySQL 5.7 and most MySQL 8.0 features. This is what most WordPress, Joomla, and Drupal installations expect.

WordPress requires MySQL 5.7+ or MariaDB 10.3+. All Ultra Web Hosting servers meet this requirement.

If an application asks for a specific MySQL version and you're running MariaDB, check the application's documentation for MariaDB compatibility. In most cases, MariaDB works identically to the MySQL version it's based on.

For connection troubleshooting, see MySQL Port 3306 Guide and Database Connection Guide.

Quick Recap: Finding Your MySQL Version

1. phpMyAdmin shows it on the home page under "Database server"
2. cPanel shows it in Server Information
3. SSH: mysql -V for a quick check
4. PHP: mysqli_get_client_info() or $conn->server_info
5. MariaDB is MySQL-compatible - most applications work identically

Last updated March 2026 · Browse all PHP/MySQL articles