Useful Raspbian commands

Check free disk space

df -h

Install MySQL Server

sudo apt-get install mysql-server

sudo mysql_secure_installation

sudo mysql -u root -p

sudo apt-get install python-mysqldb

sudo mysql -u root -p

GRANT ALL PRIVILEGES ON mydb.* TO 'username'@'localhost' IDENTIFIED BY 'password';

https://pimylifeup.com/raspberry-pi-mysql-phpmyadmin/

Install myPHPAdmin

sudo apt-get install phpmyadmin

Restart Apache server

sudo service apache2 restart

Restart MySQL server

sudo service mysql restart

Change file permissions

sudo chmod -R 777 phpmyadmin

Edit phpmyadmin blowfish configuration file

sudo nano /var/lib/phpmyadmin/blowfish_secret.inc.php
sudo nano /etc/phpMyAdmin/config.inc.php