Ghost is saying I'm using MariaDB, but I am using MySQL

Hello forum :raised_hand_with_fingers_splayed:t2:
I have just updated Ghost on my Docker installation to the latest version (5.9.4).
I did a complete migration of the SQLite database to a MySQL server I own and tested it, everything’s working and all the posts and pages are here.

Just a minor issue, which bother me a bit: Ghost says that I am using a MariaDB database, while I am really using a MySQL database.

Here what Ghost says:

And next, my current MySQL databases:

Is there any suggestion you would give to me in order to find what’s wrong with the configuration? I hardcoded the configuration of the MySQL server, so I made it very clear that is that type of database.

Many thanks for any help :blush:

Hey @mceyes :wave: Would you be able to run SELECT version() as version; in a MySQL terminal, and paste the result here please? :slightly_smiling_face:

Ok this is something I wasn’t expecting… There is actually a MariaDB database installed instead of MySQL on my environment :scream:

MariaDB [(none)]> SELECT version() as version;
| version                 |
| 10.5.16-MariaDB-cll-lve |
1 row in set (0.000 sec)

I’m seeing that MariaDB is the database application delivered with XAMPP nowadays (there are posts on StackOverflow since at least 2020).

This is the terminal output if I ask for help to MySQL:

[mceyes@rs-fra ~] $ mysql --verbose --help
mysql  Ver 15.1 Distrib 10.5.16-MariaDB, for Linux (x86_64) using readline 5.1
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Usage: mysql [OPTIONS] [database]

I think I will ask my hosting support center to remove MariaDB and keep just the MySQL database application.
Any hints about this? What would you do/suggest?


Haha - no worries! I can’t attest to how you get it switched to MySQL, but there’s another post on the forum for switching from MariaDB to MySQL 8, which might be useful :slightly_smiling_face:

Many thanks! I will give it a try.
In the meantime I will think about buying another VPS in order to separate the DB application from the Ghost installation.

I suppose there is no other issue here :grin:
Thanks for the fast support, have a good one!