Join Log in
Score:0
acgbox avatar Ubuntu

How can I change MariaDB to MySQL in XAMPP for Ubuntu (20.04)?

tr flag
acgbox

there are many "howto" of how to change mariadb to mysql in xampp (HERE, HERE, HERE, HERE, etc, etc.), but they are all for windows OS

Anyone know how to do it, for Ubuntu 20.04, by bash command line? (preferably to mysql 5.7)

wget https://www.apachefriends.org/xampp-files/7.4.12/xampp-linux-x64-7.4.12-0-installer.run
sudo chmod +x xampp-linux-x64-7.4.12-0-installer.run
sudo ./xampp-linux-x64-7.4.12-0-installer.run --mode unattended --launchapps 0
sudo /opt/lampp/manager-linux-x64.run

wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.35-linux-glibc2.12-x86_64.tar.gz
tar -xzf mysql-5.7.35-linux-glibc2.12-x86_64.tar.gz
sudo mv -f mysql-5.7.35-linux-glibc2.12-x86_64/* /opt/lampp/mysql

# and after that?

enter image description here

workaround to downgrade:

There is no version of Xampp with MySQL 5.7. According to Apache Friends, since XAMPP 5.5.30 and 5.6.14, XAMPP ships MariaDB instead of MySQL (According to RELEASE NOTES, last Xampp with MySQL was v5.6.12-0 -with MySQL v5.6.25-; then jumped to Xampp v5.6.14 -with MariaDB v10.0.17-)

RELEASE NOTES

[2015-10-19] XAMPP for Linux 64bit 5.6.14
This version of XAMPP includes:
    - Updated Apache to 2.4.17
    - Updated PHP to 5.6.14
    - Added MariaDB 10.0.17
    - Updated phpMyAdmin 4.5.0.2

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

[2015-08-27] XAMPP for Linux 64bit 5.6.12-0
This version of XAMPP includes:
    - Updated Apache to 2.4.12
    - Updated PHP to 5.6.11
    - Updated MySQL to 5.6.25
    - Updated phpMyAdmin 4.4.12
    - Update OpenSSL to 1.0.1p
    - Phanebook issue with SQLite
    - Fix charset admin pages
    - Added OS X HOW-TO guides
    - Enabled SSL support for PostgreSQL PHP extension
    - Added PHP XMLRPC extension
    - Added PHP MSSQL extension
    - Included new dashboard

So i found a package called bitnami lamp, and in previous versions it has one with mysql 5.7 and can downgrade

enter image description here

but still, I would like to know the answer to my question, if such a thing can be done in linux

296
0 + 0
in flag
matigo
You may want to ask on [a XAMPP-specific site](https://www.apachefriends.org/community.html) as the project does a lot of non-standard things with installations, configurations, and the like. If you’re looking for a modern means of running an older version of MySQL, you may find that Docker containers are a flexible way to go
0
Reply
acgbox avatar
tr flag
acgbox
I can't downgrade because there is no Xampp version with mysql 5.7. In the forum nobody says anything about my question. Windows only. That's why I'm here.
0
Reply
in flag
matigo
Fun. Well, in that case, I would advise learning how Docker containers work, and spinning one up with 5.7. As I said earlier, XAMPP does non-standard things with its version of Apache/MySQL/PHP/PostgreSQL, so swapping out versions is likely to have a lot of gotchas and other painful things that people shouldn't have to struggle with. Docker may be aptly suited for your needs ... though there is a slight learning curve involved
0
Reply
ธงชาติไทย
Elon Musk
I sit in a Tesla and translated this thread with Ai:

mangohost

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.