Home / ubuntu / Questions / 976915
Accepted
Jos
Asked: 2017-11-16 22:00:28 +0800 CST

how to check if a database is mysql or mariadb

  • 772

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

mysql

4 Answers

  1. Best Answer

    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

    • 18

  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
    • 7

  3. If you can perform a query :

    SELECT VERSION();

    I tested on a mariadb server and it shows :

    5.5.60-MariaDB
    • 3

  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)

    • 2