Home > English > Tutorials > How to install PHPMyAdmin on Ubuntu 14 ( for LAMP)

How to install PHPMyAdmin on Ubuntu 14 ( for LAMP)

 

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