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?

Are we talking about a raw database file or a running database? — George Udosen, Nov 16 '17 at 06:08
@neferpitou Yes. I'm not sure which of the two is installed in Lampp. I have a Akeeba backup that installs (thank god!) well on the live server, but acts weird when I install it on my localhost. — Jos, Nov 16 '17 at 07:15
dpkg -l | grep mysql and for mariadb dpkg -l grep mariadb; if it shows nothing then it is not installed. — neferpitou, Nov 16 '17 at 08:16

Ibijola Adetayo · Accepted Answer · 2017-11-17T21:07:46.370

20

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 page Maria Welcome page

edited Nov 17 '17 at 21:07

answered Nov 16 '17 at 08:32

Ibijola Adetayo

316

score 8 · Answer 2 · edited Feb 15 '20 at 21:09

8

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

edited Feb 15 '20 at 21:09

rosch

8,198

answered Nov 16 '17 at 07:52

sys0dm1n

343

dpkg command not found.... – Richard Fu Apr 30 '19 at 05:26
3

@RichardFu Which distro you are using? You might need to use this one instead: rpm -qa | grep -e mysql -e mariadb – sys0dm1n May 07 '19 at 08:10

score 7 · Answer 3 · answered Dec 18 '20 at 13:46

7

If you can perform a query :

SELECT VERSION();

I tested on a mariadb server and it shows :

5.5.60-MariaDB

answered Dec 18 '20 at 13:46

Clemorphy

171

3

For me: the result is "8.0.23-0ubuntu0.20.04.1" – The Anh Nguyen Mar 16 '21 at 07:33
Yes, on MySQL only the version number (8.0.23 here) is in there, and the database type is not shown. So this isn't a great answer. – rfay Jan 03 '22 at 15:00

score 5 · Answer 4 · answered Jan 29 '21 at 09:15

5

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)

answered Jan 29 '21 at 09:15

Adam

51

3

For me: "version_comment" is "(Ubuntu)" ? – The Anh Nguyen Mar 16 '21 at 07:32
This does not result in "MySQL Community Server" on a mysql server. – rfay Jan 03 '22 at 15:02
Yes, It is Showing version_comment as MariaDB Server in SQL Query – Chandan Sharma Mar 21 '23 at 07:18

how to check if a database is mysql or mariadb

4 Answers4