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

 - 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

ipkg install php-mbstring php-mysql

9 - Restart lighttpd

/opt/etc/init.d/S80lighttpd restart

10 - Go to your router ip address and port 81/phpmyadmin or www.asusrouter.com:81/phpmyadmin

phpmyadmin111 - Input credentials from point 6 then press Go

phpmyadmin2

Now you are ready to make changes on desired databases

 


 

SUBSCRIBE

To be notified by email when a new tutorial is posted :)

Thanks for Subscribing! I'll keeping you up-to-date with latest tutorials!

Something went wrong, try again...