title: How can I change the type of database in phpmyadmin from mariadb to mysql?
body: <p>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.</p>
  
  <p>My queries don't work on:</p>
  
  <pre><code>Server type: MariaDB
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/4cxta.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/4cxta.png" alt="enter image description here"></a></p>
  
  <p>They do work on:</p>
  
  <pre><code>Server type: Mysql
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/ZHL4Q.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ZHL4Q.png" alt="enter image description here"></a></p>
  
  <p>How can I change it from MariaDB to Mysql then?</p>