18

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

4
  • Are we talking about a raw database file or a running database? 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

18

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

7

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
2
  • dpkg command not found....
    – Richard Fu
    Apr 30, 2019 at 5:26
  • 2
    @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
3

If you can perform a query :

SELECT VERSION();

I tested on a mariadb server and it shows :

5.5.60-MariaDB
2
  • 1
    For me: the result is "8.0.23-0ubuntu0.20.04.1" 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 at 15:00
2

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)

2
  • 1
    For me: "version_comment" is "(Ubuntu)" ? Mar 16, 2021 at 7:32
  • This does not result in "MySQL Community Server" on a mysql server.
    – rfay
    Jan 3 at 15:02

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.