Introduction

phpMyAdmin is a free and open source tool written in PHP intended to handle the administration of MySQL with the use of a web browser.

To install phpMyAdmin open the terminal and type these commands:

sudo apt-get update
sudo apt-get install phpmyadmin php-mbstring php-gettext

WARNING: During installation Apache2 is highlighted, but not selected. You must hit Space to select Apache, then the installer will move the necessary files during installation. Hit Space, Tab, and then Enter to select Apache.

  • Select YES when asked whether to use dbconfig-common to set up the database.

  • Insert your database administrator's password.

  • Choose and confirm a password for the phpMyAdmin application.

Enable the PHP mcrypt and mbstring extensions:

sudo phpenmod mcrypt
sudo phpenmod mbstring

Restart Apache2:

sudo service apache2 restart

You can now access the web interface by visiting your server's domain name or public IP address followed by /phpmyadmin:

http://your_domain/phpmyadmin

http://localhost/phpmyadmin

The installation is now complete with basic configurations.