RequrementsBefore working with phpMyAdmin you need to have LAMP installed on your server. If you don't have the Linux, Apache, MySQL, PHP stack on your server, you can find the tutorial for setting it up
here.
Install phpMyAdminThe easiest way to install phpMyAdmin is through apt-get:
sudo apt-get install phpmyadmin apache2-utils
During the installation, phpMyAdmin will walk you through a basic configuration. Once the process starts up, follow these steps:
- Select Apache2 for the server
- Choose YES when asked about whether to Configure the database for phpmyadmin with dbconfig-common
- Enter your MySQL password when prompted
- Enter the password that you want to use to log into phpmyadmin
After the installation has completed, add phpMyAdmin to the Apache configuration.
sudo nano /etc/apache2/apache2.conf
Add folowing line:
Include /etc/phpmyadmin/apache.conf
Save and exit ( Ctrl + O, Ctrl + X).
Restart Apache with command:
sudo service apache2 restart
You can then access phpMyAdmin by going to:
http://your_ip_address/phpmyadmin