Steps to Upgrade MariaDB for XAMPP

I’m a fan of short articles/news!

Tested: Upgrading to MariaDB 10.2 for XAMPP v7.1.4

  1. Download an installer of the latest stable version of MariaDB
  2. Be sure all modules are stopped from the XAMPP Control Panel
  3. Rename (xampp path)/mysql to something else (i.e. mysql-old)
  4. Install the downloaded MariaDB to the (xampp path)/mysql
  5. Copy the mysql-old/bin/my.ini file to mysql/bin directory
  6. Copy all .ini and .bat files from mysql-old root to the mysql root
  7. Copy the whole mysql-old/data/phpmyadmin directory to mysql/data
  8. Copy the mysql-old/data/ibdata1 file to mysql/data
  9. Run Apache and MySQL modules from the XAMPP Control Panel
  10. If both modules started correctly, run a CMD as administrator, then enter mysql-upgrade -force -username=root -password command (If your username is different, change the root to your username, and change single dash character to double dash characters)
  11. If above command successfully was done, restart your computer once, and start using new MariaDB ;)