XAMPP - Replacing MariaDB with MySQL

xmapp-replacing-mariadb-with-mysql.md

XAMPP - Replacing MariaDB with MySQL

This post has been deleted.

ah still not working. MySQL Workbench not liking it. screenshot below ...

thank you so much

@yiiprogrammer @devshark

You can create a fresh data directory with this command:

cd c:\xampp\mysql
c:\xampp\mysql>bin\mysqld.exe --initialize-insecure --basedir=c:\xampp\mysql --datadir=c:\xampp\mysql\data

May be useful to include a link to https://github.com/phpmyadmin/phpmyadmin/blob/master/sql/create_tables.sql

If the user decides against importing their old data, their phpmyadmin will break unless they run the above script :)

I think you miss one folder (\bin) on the route
Create a new file: c:\xampp\mysql\my.ini and copy this content:

It should be
Create a new file: c:\xampp\mysql\bin\my.ini and copy this content:

I cant start mysql from xampp

@akaki1991

Make sure you have installed the 32-bit version of MySQL. The 64-bit version is not compatible with the XAMPP Control Panel.

my.ini needs to be in /bin unlike original instructions - otherwise works
thanks @addylov89 for pointing that out

Thank you for the tut, it helped me a lot. About the start/stop issue, @addylov89 solves it.

Worked like charm. Replaced MariaDB 10.1.34 with MySQL 5.6.41.
Now MySQL Workbench works well with MySQL on XAMPP.
Thanks

my.ini should be in the bin directory

Yes move my.ini should be in the bin directory
Work now

Worked like a charm. Cheers guys. my.ini does need to be in the bin directory, indeed.

The MySQL server should be restarted after the mysql_upgrade.exe command, otherwise there might be errors.

See: https://stackoverflow.com/questions/6288103/native-table-performance-schema-has-the-wrong-structure

Is it possible to do the same for mac OS?

Hello @odan, i faced mysqld.exe - System error.

The code execution cannot proceed because msvcr120.dll was not found. Reinstalling the program may fix this problem.
Please help me.

Thank you.

@akaki1991

Make sure you have installed the 32-bit version of MySQL. The 64-bit version is not compatible with the XAMPP Control Panel.

Worst news :(
Btw, would be great to see in the https://odan.github.io/2019/11/17/xampp-replacing-mariadb-with-mysql-8.html description
This answer sold my problem 👍

I have followed all the steps its still not working,

The code execution cannot proceed because msvcr120.dll was not found. Reinstalling the program may fix this problem.

installed the 32 bit updated my.ini

@loyison The file MSVCR120.dll should be part of the Microsoft Visual C++ 2013 Redistributable Package

https://www.microsoft.com/en-us/download/details.aspx?id=40784

Links aren't working anymore

Bad... The links are broken... maybe Takedown?

@enigmaelectronica Sorry, the page has been deleted.