Install PHPMyAdmin on Debian 10 (user root no password)

Installing LAMP with PMA on debian 10.md

Install PHPMyAdmin on Debian 10

User root with no password

1. Install LAMP apt install apache2 php mariadb-server

2. Install PHP modules apt install php-{mbstring,zip,gd,xml,pear,gettext,cgi,mysql} libapache2-mod-php

3. Download PHPMyAdmin apt install wget wget https://files.phpmyadmin.net/phpMyAdmin/5.0.4/phpMyAdmin-5.0.4-all-languages.tar.gz

4. Create phpmyadmin directory and copy everything in mkdir /var/www/html/phpmyadmin tar xzf phpMyAdmin-5.0.4-all-languages.tar.gz --strip-components=1 -C /var/www/html/phpmyadmin

5. Create PHPMyAdmin config cp /var/www/html/phpmyadmin/config{.sample,}.inc.php nano /var/www/html/phpmyadmin/config.inc.php --> look for "AllowNoPassword" with Ctrl W set FALSE on TRUE it gives something like that:

$cfg['Servers'][$i]['AllowNoPassword'] = true;

6. Give the permissions from the config file (otherwise the config doesn't work, it's a PMA rule) chmod 660 /var/www/html/phpmyadmin/config.inc.php chown -R www-data:www-data /var/www/html/phpmyadmin

7. Restart apache systemctl restart apache2

8. Allow root for PHPMyAdmin mysql -u root

USE mysql;
UPDATE user SET plugin='mysql_native_password' WHERE User='root';
FLUSH PRIVILEGES;
exit;

Then restart mariadb systemctl restart mysql

pma_install_deb10.sh

#!/bin/bash

# You can exec directly by typing this command
# (if curl is installed else install it with "apt install curl -y")
# curl -sL https://gist.githubusercontent.com/GreepTheSheep/25f373f78f10b818be97c628abb81246/raw/pma_install_deb10.sh | bash -

echo "# LAMP + PHPMyAdmin full installation on Debian 10"
echo "# By Greep"
echo "--------------------------------------------------"
echo ""

echo "# Updating packages list"
apt update

echo "# Installing apache2 + PHP + MariaDB services"
apt install apache2 php mariadb-server -y

echo "# Installing PHP modules"
apt install php-{mbstring,zip,gd,xml,pear,gettext,cgi,mysql} libapache2-mod-php -y

echo "# Installing wget"
apt install wget -y

echo "# Downloading PHPMyAdmin 5.0.4"
wget https://files.phpmyadmin.net/phpMyAdmin/5.0.4/phpMyAdmin-5.0.4-all-languages.tar.gz

echo "# Creating PHPMyAdmin directory and coping content on it"
mkdir /var/www/html/phpmyadmin
tar xzf phpMyAdmin-5.0.4-all-languages.tar.gz --strip-components=1 -C /var/www/html/phpmyadmin

echo "# Creating PHPMyAdmin config file..."
cp /var/www/html/phpmyadmin/config{.sample,}.inc.php

echo "# Giving permissions to the config file"
chmod 660 /var/www/html/phpmyadmin/config.inc.php
chown -R www-data:www-data /var/www/html/phpmyadmin

echo "# Restarting apache2"
systemctl restart apache2

echo "# Connecting to MariaDB server and authorizing root to PHPMyAdmin"
mysql -u root -D mysql -e "UPDATE user SET plugin='mysql_native_password' WHERE User='root';FLUSH PRIVILEGES;"

echo "------------------------------------------"
echo "Done!"
echo "Before you start please run 'mysql_secure_installation' and set a new password to root"
echo "Then you can login as root on http://localhost/phpmyadmin"
echo "Happy coding!"