phpMyAdmin

phpMyAdmin ".. is a free software tool written in PHP, intended to handle the administration of MySQL over the Web.". It is an invaluable asset to your web server and management of your MySQL database

To install phpMyAdmin

Log in as root privileged su:
Just in case, update your system ...

BPiM5:yourname:# apt-get update -y && apt-get upgrade -y

Install phpMyAdmin ..

BPiM5:yourname:# apt-get install -y phpmyadmin

When asked to choose "Apache2" or "lighttpd" press 'Space bar' in whilst "apache 2" is highlighted (a * will show it's selected) and then press tab to highlight OK; and press enter.

The next question will be about "Configure database for phpmyadmin with sbconfig-common" - Answer: Yes

Next enter a password of your choice (and re-enter). Note: the curser does not move when typing in this password. It's a little disconcerting!

Next you need to authorise YOU as a phpMyAdmin user in MySQL. To start you log into MySQL as root.....

BPiM5:yourname:# mysql --user=root mysql

...and enter the root password you entered earlier.

Next, create a new user account for YOU under your username

mysql> CREATE USER 'your user name'@'localhost' IDENTIFIED BY 'your password';

If your user name is fred and password 123456 ... the line would be ...

mysql> CREATE USER 'fred'@'localhost' IDENTIFIED BY '123456';

Followed by ...

mysql> GRANT ALL PRIVILEGES ON *.* TO 'your user name'@'localhost';

Followed by ...

mysql> EXIT

You can now log into phpMyAdmin, type in your web browser's adress bar: [IP address of BPi-M5]/phpmyadmin (e.g. 192.168.1.100/phpmyadmin)
and enter your username and password.

Next step: installing web hosting software - FTP server Next