Installing PHPMyAdmin in DigitalOcean
Getting Started:
Install packages
sudo apt update
sudo apt install phpmyadmin php-mbstring php-zip php-gd php-json php-curl
When prompted "Configuring phpmyadmin"
Press SPACEBAR, then TAB, then ENTER.
When prompted "Configuring phpmyadmin" again
Press TAB, then ENTER
Enable mbstring
sudo phpenmod mbstring
Restart the server
sudo systemctl restart apache2
MySQL user:
sudo mysql
Inside mysql:
CREATE USER 'admin'@'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON *.* TO 'admin'@'localhost' WITH GRANT OPTION;
making it secure: https://www.digitalocean.com/community/tutorials/how-to-install-and-secure-phpmyadmin-on-ubuntu-20-04