XAMPP – Replacing MariaDB with MySQL 8 on Windows 10

Last Updated on May 20, 2020 by Vikash Ekka

How can we change MariaDB to MySQL in XAMPP  on Windows 10

Installations:-

Step1. Download the MySQl Community Server from below link                                         https://dev.mysql.com/downloads/mysql   as zip archive (Windows 64 bit version)

Step2. Select the MySQL version that you want to install on Xampp 
               
Here we are taking MySQL 8.0 

Or If you need different MySQL version then follow below image.

a.

b.

c.

cd C:xamppmysql
binmysqld --initialize-insecure
start /b binmysqld
binmysql -u root
    CREATE USER pma@localhost;
    SOURCE C:/xampp/phpMyAdmin/sql/create_tables.sql;
    GRANT SELECT, INSERT, DELETE, UPDATE, ALTER ON phpmyadmin.* TO pma@localhost;
    ALTER USER root@localhost IDENTIFIED WITH mysql_native_password BY '';
    ALTER USER pma@localhost IDENTIFIED WITH mysql_native_password BY '';
    q
binmysqladmin -u root shutdown

For MySQL 5.7 

cd C:xamppmysql
binmysqld --initialize-insecure --log_syslog=0
start /b binmysqld --log_syslog=0
binmysql -u root
    CREATE USER pma@localhost;
    SOURCE C:/xampp/phpMyAdmin/sql/create_tables.sql;
    GRANT SELECT, INSERT, DELETE, UPDATE, ALTER ON phpmyadmin.* TO pma@localhost;
    q
binmysqladmin -u root shutdown

Step8. Start Apache and MySQL in the XAMPP Control Panel.

To verify login to http://localhost/phpmyadmin and check at the right side of the page 

Conclusion

Hey, You have successfully changed or replaced mariadb with Mysql 8.0 on windows 10 operating system. 

Also Read:-

Download Windows 10 May 2020 Latest ISO images 32-bit and 64-bit Edition