how to check if a database is mysql or mariadb

Question

I have some problems with a database. I think it might be mysql, my own database is probably mariadb. How can I check that?

Answer 1

You can do this on your login to the database from the terminal:

mysql -u user -p

Enter your password and it displays the database name with the welcome message.mysql welcome pageMaria Welcome page

Answer 2

Since you mentioned Lampp, this means you have Linux, Apache, MySQL, PHP and phpmyadmin. Use this command to see what is installed on your machine, Mysql or mariadb.

dpkg -l | grep -e mysql-server -e mariadb-server

Answer 3

If you can perform a query :

SELECT VERSION();

I tested on a mariadb server and it shows :

5.5.60-MariaDB

Answer 4

If you can perform a query then i would suggest:

SHOW VARIABLES LIKE "%version%";

then look for version_comment you should see something like MariaDB Server OR MySQL Community Server (GPL)