WordPress Blog Server through Entware-NG

REQUIREMENTS:
1) RMerlin's firmware from here
2) Entware-NG must be setup from here
3) Lighttpd web server from this guide

If you meet all the requirements, login to router with putty terminal and enter:

opkg install mysql-server
opkg install wget
opkg install php5-mod-mysql
mysql_install_db --force
/opt/etc/init.d/S70mysqld restart
mysql -u root

Choose a username and a password for your database and replace those in red color

mysql> create database wordpress;
mysql> grant all privileges on wordpress.* to user_name@localhost identified by 'db_password' ;

Exit with Ctrl-C

/opt/etc/init.d/S80lighttpd restart
cd /opt/share/www
wget https://wordpress.org/latest.tar.gz --no-check-certificate && tar -zxvf latest.tar.gz && rm latest.tar.gz
chown -R admin: wordpress

Go to 192.168.1.1:81/wordpress/wp-admin/install.php
Choose a language
Click on Create a Configuration File
On the next page click on "Let's go!"
Now fill in with user_name and db_password created earlier with mysql commands.
Change Database Host from localhost to 127.0.0.1
Press "Submit"
On the next page, click on "Run the install"
Choose a Site Title, username, password (don't have to be the same as for mysql)
Enter your email adress
Press "Install WordPress"
Log in
Customize appearance, add widgets, menus, plugins...
Now access your blog on 192.168.1.1:81/wordpress to see how it looks.
Create an asus, no-ip or dyndns dynamic dns account and the blog can be accessed from your_dns_account/wordpress or your_wan_ip_adress/wordpress


Create a backup of your blog and mysql database directly from the router, (if your usb disk has a label, change sda1 with usb label)

cd /mnt/sda1
tar -zcvf wordpress.tar.gz /mnt/sda1/entware-ng/share/www/wordpress/
tar -zcvf wordpress_db.tar.gz /mnt/sda1/entware-ng/etc/mysql/wordpress

If something goes wrong, just restore with:

cd /
tar -zxvf /mnt/sda1/wordpress.tar.gz
tar -zxvf /mnt/sda1/wordpress_db.tar.gz

I hope everything goes smoothly for you, if not, don't hesitate to ask here.

See HERE a terminal recording

Youtube video HERE
youtube

Tested at 14/03/2016 on RT-AC68U, wordpress v4.4.2