How To Install MySQL Server + phpMyAdmin through Optware-NG

1 - Install Optware-NG from here and choose 2GB swap file

2 - Install lighttpd web server and php from here

3 - Install MySQL (ignore InnoDB: posix_fallocate errors)

ipkg install mysql

4 - Create a password for mysql root user, confirm password and press ENTER

/opt/bin/mysqladmin password

5 - Login to mysql shell

mysql -u root -p

6 - Create your first database, user and password (change values in red)

mysql> create database my_first_db;

mysql> grant all privileges on my_first_db.* to my_first_db_username@localhost identified by 'my_first_db_password';

mysql> quit

7 - Download phpMyAdmin (change version number if is updated)

cd /opt/share/www/

wget https://files.phpmyadmin.net/phpMyAdmin/4.6.5.2/phpMyAdmin-4.6.5.2-all-languages.zip --no-check-certificate

unzip phpMyAdmin-4.6.5.2-all-languages.zip

mv ./phpMyAdmin-4.6.5.2-all-languages ./phpmyadmin

8 - Install required packages