how to check if a database is mysql or mariadb

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

4 Answers

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

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

If you can perform a query :

SELECT VERSION();

I tested on a mariadb server and it shows :

5.5.60-MariaDB

2

If you can perform a query then i would suggest:

SHOW VARIABLES LIKE "%version%";

then look for version_commentyou should see something likeMariaDB Server OR MySQL Community Server (GPL)

2

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password Submit

Post as a guest

Post Your Answer Discard

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