'How can I change the type of database in phpmyadmin from mariadb to mysql?

I'm using phpmyadmin with xampp on both of my home and work machines. Some queries didn't work for me when I was working on one computer, but it worked on another. I checked it and the only difference is in the database server type.

My queries don't work on:

Server type: MariaDB

enter image description here

They do work on:

Server type: Mysql

enter image description here

How can I change it from MariaDB to Mysql then?

mysqlphpmyadminmariadb


Solution 1:[1]

The answer to this difference is here:

https://mariadb.com/kb/en/mariadb/mariadb-vs-mysql-compatibility/

I don't quite know what you queries you are having trouble with but this should get you started.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 abhiravi

Related Questions