phpMyAdmin provides a popular an easy to use open-source MySQL management GUI.
-
Install phpMyAdmin
$ sudo apt-get update $ sudo apt-get install phpmyadmin
When prompted for server type, hit tab and choose neither one. When prompoted for database configuration, select dbconfig-common 2. Create symbolic link and restart nginx
$ sudo ln -s /usr/share/phpmyadmin /usr/share/nginx/www/phpmyadmin
-
Enable
mcrypt
on PHP module$ sudo php5enmod mcrypt $ sudo service php5-fpm restart $ sudo service nginx restart
-
You should be able to access phpmyadmin via domain_name_or_ip/phpmyadmin
Disclaimer: Take note that it is not advisable to expose phpmyadmin to the public view as this would be the perfect place for attacks to take place to compromise our database.