how to check if a database is mysql or mariadb

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