How to Install barebones PHPMyAdmin Locally on Linux with just PHP and mariadb/mysql

Install mariadb or mysql and php

# ubuntu debian pop
sudo apt install mariadb-client mariadb-server php
# arch manjaro
sudo pacman -S mariadb php
# rhel centos fedora
yum install mariadb mariadb-server php

If you don’t have mariadb locally: You can generate a starter kit

sudo mariadb-install-db --user=mysql --basedir=/usr --datadir=/var/lib/mysql
sudo systemctl start mariadb
sudo su
mysql -u root -p

Download the latest version of PhpMyAdmin from the official site: https://www.phpmyadmin.net/files/ For example, phpMyAdmin-5.0.3-all-languages.zip

cd ~/
wget https://files.phpmyadmin.net/phpMyAdmin/5.0.3/phpMyAdmin-5.0.3-all-languages.zip
unzip phpMyAdmin-5.0.3-all-languages.zip

Rename the ugly folder

mv phpMyAdmin-5.0.3-all-languages phpmyadmin

Then create a script somewhere, like on your desktop or on your launchbar.

#!/bin/bash
/usr/lib/firefox/firefox http://localhost:8123 &
sudo systemctl start mariadb &
sudo mysqladmin flush-privileges password 'root' &
php -S localhost:8123 -t ~/phpmyadmin/

Your browser should open with a rooted local phpmyadmin. Login as Username: root Password: root