What Is MariaDB and How Do I Check My Version?

When you create a "MySQL database" on FimuroHost Cloud Hosting, it's actually served by MariaDB. You don't need to do anything differently. Here's why.

MariaDB in brief

MariaDB started as a fork of MySQL, created by some of MySQL's original developers. It keeps the same data structures, indexes and SQL syntax, so it's backward compatible and works as a drop-in replacement.

• Apps that say they need "MySQL" (WordPress, WooCommerce, Joomla, Drupal, Laravel, Magento and so on) work with it without changes.
• PHP connects to it with the usual mysqli or PDO_MySQL extensions.
• Tools such as phpMyAdmin, MySQL Workbench and mysqldump work with it as normal.

Check your MariaDB version

Some software lists a minimum database version, so it's worth checking before you install. The quickest way is a one-line query:

1. Log in to your FimuroHost client area, open Services and select your hosting plan.
2. Click Login to Control Panel / StackCP. StackCP opens with the tools for that website (single sign-on, so there is no second password to type).
3. Click phpMyAdmin.
4. Select your database in the left-hand panel.
5. Open the SQL tab at the top (in some phpMyAdmin layouts, use Query).
6. Enter the query below and click Go.

SELECT VERSION();

                        
                    

The result will look something like 10.x.x-MariaDB. The number before -MariaDB is your server version. phpMyAdmin's home page also shows it under Database server → Server version.

Good to know

• A few newer MySQL 8 features, and the MySQL 8 collation utf8mb4_0900_ai_ci, aren't part of MariaDB. If an export from a MySQL 8 server won't import, replace that collation with utf8mb4_unicode_ci.
• If an application's requirements page mentions a MySQL version, check its docs for the matching MariaDB version. Most list both.

Need help?

If something doesn't work as described, open a support ticket from your client area or message us on WhatsApp at 01818160926. Tell us the domain name and what you have already tried, and we'll take it from there.