Learn how to change MariaDB to MySQL in XAMPP. Our MySQL Support team is here to help you with your questions and concerns.

How to Change MariaDB to MySQL in XAMPP

Switching from MariaDB to MySQL in your XAMPP setup can be straightforward with the right steps.

Today, our experts will walk us through the entire process.

1. First, we have to back up our existing database. So, open a terminal and run this command:

   mariadb-dump -u admin_backup -p -x -A > /data/backup/dbs.sql
2. Next, stop the MariaDB service in the XAMPP Control Panel to prevent any changes to the database during the transition.
3. Then, rename the existing MariaDB folder:

   mv c:/xampp/mysql c:/xampp/mariadb
4. Now, download the latest MySQL Community Server from this link.
5. Then, create a new MySQL folder.
   

   Subscribe to our newsletter for the latest updates, news, and features.

   Let's Go!
6. Next, extract the downloaded MySQL ZIP file into the new folder:

   unzip path_to_downloaded_mysql_zip -d c:/xampp/mysql
7. Now, create a data directory:

   mkdir c:/xampp/mysql/data
8. Then, create a new file `c:/xampp/mysql/bin/my.ini` with the following content:

   [mysqld]
# set basedir to your installation path
basedir=c:/xampp/mysql
# set datadir to the location of your data directory
datadir=c:/xampp/mysql/data

9. Now, open a new command prompt and change the directory to `c:/xampp/mysql/bin`.
10. After that, run these commands to start MySQL:

    mysqld --initialize
mysqld --initialize-insecure


    MySQL will create a `root@localhost` user with a random password. Locate this password in the `.err` file in the `c:/xampp/mysql/data` directory.
11. Then, start the MySQL service using the XAMPP Control Panel.
12. So, open a new command prompt, go to `c:/xampp/mysql/bin`, and connect to MySQL using the temporary password:

    mysql -u root -p
13. For easier access, reset the root password to an empty string:

    ALTER USER 'root'@'localhost' IDENTIFIED BY '';
14. Now, exit the MySQL prompt:

    exit;

[Need assistance with a different issue? Our team is available 24/7.]

Conclusion

With the above steps, we can replace MariaDB with MySQL in XAMPP, ensuring a smooth transition while preserving our data and configurations.

In brief, our Support Experts demonstrated how to change MariaDB to MySQL in XAMPP