using MySQL with Xampp

Alles, was MariaDB und MySQL betrifft, kann hier besprochen werden.

using MySQL with Xampp

Postby sreeju1 » 25. January 2017 06:46

I want to replace MariaDB with MySQL in XAMPP for a specific project because the MariaDB doesn't support JSON field type yet.
How do I switch it successfully so that I can use all the existing databases created using MariaDB and also the phpMyadmin with the MySQL DB?
My XAMPP version is 7.0.13. and the MySQL I want to use is 5.7.17.
sreeju1
 
Posts: 1
Joined: 25. January 2017 06:32
XAMPP version: 7.0.13
Operating System: windows 10

Re: using MySQL with Xampp

Postby Nobbie » 25. January 2017 12:08

You cannot replace MariaDB by MySQL, this is not supported by Xampp (you may try it of course, but you wont get any support).

Instead step back to an older Xampp which delivers MySQL (i dont know which was the last Xampp with MySQL, but you should find it on sourceforge).

P.S.: From my understanding, there should not be a problem out there, as Apache/PHP connects to MySQL/MariaDB via TCP/IP. Knowing that, i would simply install a MySQL Package (whatever you need) into c:/Program Files or similar (simply the default destination), then start Apache (from Xampp) but do NOT start MariaDB from Xampp, instead start your MySQL Server from that MySQL installation. I cannot see any restriction why that should not work?! There might be a problem if the PHP MySQL library interacts correctly with the Server, but you will find out that quickly with a small check (simply call PhpMyAdmin or so). If it runs, you are upset. If not, you have to go the other way, install an older Xampp.
Nobbie
 
Posts: 13170
Joined: 09. March 2008 13:04

Re: using MySQL with Xampp

Postby Altrea » 25. January 2017 16:48

Nobbie wrote:i would simply install a MySQL Package (whatever you need) into c:/Program Files or similar (simply the default destination), then start Apache (from Xampp) but do NOT start MariaDB from Xampp, instead start your MySQL Server from that MySQL installation.

I totally agree.

There are some things to know of course.
You need to install phpmyadmin on that new MySQL Database. It might be enough to create the needed database users and export the database.
You cannot start/stop the MySQL with help of the XAMPP control panel. The paths of the database binaries are hardcoded in the control panel sources.
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11926
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64


Return to MariaDB - MySQL

Who is online

Users browsing this forum: No registered users and 15 guests