Features of phpMyAdmin :
Friendly web interface
Support almost all Hỗ trợ hầu hết các tính năng MySQL functionalities:
Browse and drop database, tables, views, fileds and indexes
Creat, copy, drop, rename and change database, tables, views, fileds and indexes
Manage MySQL users and monologies
Import data from CSV and SQL
Export data in various formats such as CSV , SQL , XML , PDF , ISO / IEC 26300 - OpenDocument Text and spreadsheet, Word , LATEX and others
Manage multiple servers
Preparation
Update the latest packages
# apt-get update -y
You need 1 Ubuntu VPS installing đã cài LAMP, preference link Click here
Proceeding
Type this command to install phpMyAdmin
# apt-get install phpMyAdmin -y
During the installation, PHPMyAdmin will display an interface for you to select, select Apache2
Then select Yes to set initial passwords for phpMyAdmin.
Next edit the file /etc/apache2/apache2.conf
# nano /etc/apache2/apache2.conf
And add this phrase at the end
Include /etc/phpmyadmin/apache.conf
Restart the Apache
# service apache2 restart
Now you can visit phpMyAdmin with the link http://IP-VPS/phpmyadmin