Page 1 of 1

XAMPP Page says "MariaDB" but installs MySQL.

PostPosted: 12. June 2020 16:17
by Rabb
Hi all.

New to the forum, but not to Unix/Linux. :-)

In large bold type at the top of the XAMPP page at "https://www.apachefriends.org/index.html" it says "XAMPP Apache + MariaDB + PHP + Perl"

Wonderful! Just what I want to install on my fresh Linux server.

I downloaded "XAMPP for Linux 7.4.6."

So why does it install MySQL instead of MariaDB? And how do I change that?

Thanks a lot.

Re: XAMPP Page says "MariaDB" but installs MySQL.

PostPosted: 13. June 2020 11:15
by Altrea
Hi,

Current XAMPP releases always comes with Mariadb, independently what some labels or folders say. You can check that in the server signature you can see in phpmyadmin or the Mariadb CLI.

Re: XAMPP Page says "MariaDB" but installs MySQL.

PostPosted: 13. June 2020 15:26
by Rabb
Hi Altrea, thanks for the reply.

What you say does not match my experience, though. I downloaded and installed XAMPP from the "official" site, https://www.apachefriends.org/download.html just two days ago, and it indeed installed MySQL instead of MariaDB.

So, in this case at least, the most current release did NOT come with MariaDB.

What would you suggest as a path to getting a proper installation with MariaDB?

Thanks a lot.

Re: XAMPP Page says "MariaDB" but installs MySQL.

PostPosted: 13. June 2020 18:34
by Altrea
Ok, so i hava double checked that now on Windows 10 and Linux Ubuntu.
In both cases the server signature for MariaDB in XAMPP 7.4.6 is "Server version: 10.4.11-MariaDB"

What would you suggest as a path to getting a proper installation with MariaDB?

I don't know. I cannot see an error in the current xampp download files.
Maybe you got a different MySQL already running on your system that causes confusion, or there is any reason for you to just think you have MySQL running. You didn't tell us what makes you think it is running MySQL instead of MariaDB. On which information do you rely?

Re: XAMPP Page says "MariaDB" but installs MySQL.

PostPosted: 14. June 2020 18:18
by Rabb
Hi Altrea,

Here's the process I went through -- there may be an explanation in here...

My initial goal was to have a functional installation of NextCloud, so I can run my own cloud server (and use CardDav, CalDav, etc). I also intend to install WordPress on the server for another project on which I collaborate. I started with a fresh installation of Mint 19.3.

When I first started on installing LAMP, I initially followed advice on several web pages that guided me through installing each of the components independently: Apache2, MariaDB, and PHP.

It was after I had started on that that a friend mentioned the XAMPP project, which sounds like a simpler, integrated, all-in-one installation.

So, I installed XAMPP. I _assumed_ (perhaps mistakenly) that it would either make use of the components I had already installed, or overwrite them.

After that installation I noticed that I now had MySQL on the server. It wasn't installed previously, so it appears that the only place it could have come from was the XAMPP installation. The XAMPP window also mentioned starting and stopping the various servers, including MySQL (not MariaDB).

If XAMPP sees that MariaDB is already installed, does it automatically install MySQL?

In any case, I'm going to remove everything, and start again from scratch with a fresh install of XAMPP.

Any thoughts appreciated.

Thanks!

Re: XAMPP Page says "MariaDB" but installs MySQL.

PostPosted: 14. June 2020 18:31
by Altrea
Rabb wrote:After that installation I noticed that I now had MySQL on the server.

What exactly makes you so sure that this is in fact an mysql installation? Because the folder /opt/lampp/mysql is named so? Because it is written in the xampp manager?
Both are only fragments of the past for compatibility reasons because some things in the manager are hardcoded to these names.
But in fact it is a MariaDB installation.

Rabb wrote:If XAMPP sees that MariaDB is already installed, does it automatically install MySQL?

No.

Re: XAMPP Page says "MariaDB" but installs MySQL.

PostPosted: 14. June 2020 20:50
by Rabb
"What exactly makes you so sure that this is in fact an mysql installation?"

The fact that
$ which mysql
usr/bin/mysql

$ which mariadb
/usr/bin/mariadb

I didn't intentionally install mysql.

In any case, this intended-to-be polite and friendly discussion seems to be becoming confrontational, unfortunately.

Thanks for your time. I hope a full reinstallation will work out.

Re: XAMPP Page says "MariaDB" but installs MySQL.

PostPosted: 14. June 2020 21:17
by Altrea
All components xampp installs are inside folder /opt/lampp/

So this mysql installation in /usr/bin/mysql must have come from somewhere else.

I am sorry if that sounds impolite or confrontational for you, that was not my intention. I just wanted to understand which information you have and where they come from.