24

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

Improve this question
4
  • Are we talking about a raw database file or a running database?
    – George Udosen
    Nov 16, 2017 at 6:08
  • You want to check weather mariadb is installed or not?
    – neferpitou
    Nov 16, 2017 at 6:31
  • @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, 2017 at 7:15
  • dpkg -l | grep mysql and for mariadb dpkg -l grep mariadb; if it shows nothing then it is not installed.
    – neferpitou
    Nov 16, 2017 at 8:16

4 Answers 4

Reset to default
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 pageMaria Welcome page

Improve this answer
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
Improve this answer
2
  • dpkg command not found....
    – Richard Fu
    Apr 30, 2019 at 5: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 7, 2019 at 8:10
6

If you can perform a query :

SELECT VERSION();

I tested on a mariadb server and it shows :

5.5.60-MariaDB
Improve this answer
2
  • 2
    For me: the result is "8.0.23-0ubuntu0.20.04.1"
    – The Anh Nguyen
    Mar 16, 2021 at 7: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 3, 2022 at 15:00
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)

Improve this answer
3
  • 1
    For me: "version_comment" is "(Ubuntu)" ?
    – The Anh Nguyen
    Mar 16, 2021 at 7:32
  • This does not result in "MySQL Community Server" on a mysql server.
    – rfay
    Jan 3, 2022 at 15:02
  • Yes, It is Showing version_comment as MariaDB Server in SQL Query
    – Chandan Sharma
    Mar 21, 2023 at 7:18

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .