Puppy Linux Discussion Forum

Some time ago I've tried to install Apache, PHP7 and MySql on Puppy (I believe it was Bionic) from scratch. I managed to get Apache and PHP7 working by installing the files from PPM but I failed to get MySql working. I didn't wrote it down somewhere so I will have another go at it on Fossa. Because my time ran out I had to switch to Ubuntu where the install was pretty easy. I was learning Symfony so I had to have a 'quick fix' for a server package. Sorry about that
I don' t want old stuff so my goal now is: Fossa+ Apache2 + PHP7 and MySql. As Admin I want to use Adminer, not PHPAdmin.
Now somewhere I've heard about a replacement for apt-install that was called dpkg I believe so you could install packages from the Ubuntu repository, but I can't seem to find a manual for that.
Another fast way to get a server up and running is the live server from Dog Linux: works like a dream I must say. You can download it here: https://github.com/mbinnun/MBPUP/blob/master/README.md. But.. it's not so different from a normal Ubuntu installation and it's really made for a server package 'on the go'. But it saved my xxx multiple times to be honest.
And how about installing it from .tar with configure, make and make install? Haven't figured that out yet.

I'll keep y'all posted.

you can install the mysql server from the PPM, but you will need to do some steps manually to configure and start it. Or run this script:

#!/bin/sh

# # create the user for the mysql server
adduser mysql -D

# install the mysql server and intialize it
pkg add mariadb mariadb-server

# create run time directories and set the correct permissions and ownership
[ ! -d  /var/run/mysqld ]  && mkdir /var/run/mysqld

chown -R mysql /var/run/mysqld
mysql_install_db
sleep 2
mysqld  &
sleep 2
 
 echo "Make sure that NOBODY can access the server without a password"
 
# Make sure that NOBODY can access the server without a password
mysql -e "UPDATE mysql.user SET Password = PASSWORD('admin') WHERE User = 'root'"

# Kill the anonymous users
mysql -e "DROP USER ''@'localhost'"

# Because our hostname varies we'll use some Bash magic here.
mysql -e "DROP USER ''@'$(hostname)'"

# Make our changes take effect
mysql -e "FLUSH PRIVILEGES"

echo "Finished stage 1. mariadb is installed"

you can do each step manually as well. If you run into a message of depreciation on the usage of:

mysql -e "UPDATE mysql.user SET Password = PASSWORD('admin') WHERE User = 'root'"

we can adjust the statement.

Also if you want to use the PPM and not Pkg that will work just as well, and you will need to do those manual steps using this method as well.

Well I'm always a bit lazy and I found a Xampp 7.3.3-1 sfs that seems to work fine. I've tested it with Puppy Fossa and dpup Buster. I've put it on my Google drive https://drive.google.com/file/d/17rq-n_ ... sp=sharing.