How to Switch from MariaDB to MySQL in XAMPP?

Switching from MariaDB to MySQL in XAMPP

For users seeking to utilize MySQL Workbench and avoid compatibility issues, switching from MariaDB to MySQL in XAMPP is necessary. Here's an extensive guide:

Step-by-Step Instructions:

1. Halt MariaDB: Stop MariaDB in the XAMPP Control Panel.
2. Download MySQL: Acquire the MySQL community server as a zip archive for Windows 64 bit.
3. Rename Directory: Rename C:xamppmysql to C:xamppmariadb.
4. Extract MySQL: Unpack the downloaded zip archive to C:xamppmysql.
5. Copy my.ini: Transfer C:xamppmariadbbinmy.ini to C:xamppmysqlbin.
6. Modify my.ini: In C:xamppmysqlbinmy.ini, comment out the line starting with key_buffer= under the [mysqld] section.

7. Initialize and Start MySQL:

   For MySQL 8.0.18:

   • cd C:xamppmysql
   • binmysqld --initialize-insecure
   • start /b binmysqld
   • binmysql -u root
   • Create a user and import create_tables.sql
   • binmysqladmin -u root shutdown

   For MySQL 5.7.28:

   • cd C:xamppmysql
   • binmysqld --initialize-insecure --log_syslog=0
   • start /b binmysqld --log_syslog=0
   • binmysql -u root
   • Create a user and import create_tables.sql
   • binmysqladmin -u root shutdown
8. Start Services: Launch Apache and MySQL in the XAMPP Control Panel.
9. Verify: Visit http://localhost/phpmyadmin and confirm that your database server is now registered as MySQL Community Server.

The above is the detailed content of How to Switch from MariaDB to MySQL in XAMPP?. For more information, please follow other related articles on the PHP Chinese website!