Install PhpMyAdmin – Ubuntu 14.04 – Lamp
In this tutorial I will show you how to setup PhpMyAdmin. As always my platform is a LAMP stack running on a headless Ubuntu 14.04 LTS server edition.
PhpMyAdmin is a great tool to manage your Mysql database with a simple but powerful web interface. You can create users and database tables and delete them as well, so you don’t have to use the terminal for creating new databases and db users.
Step 1. Install PhpMyAdmin
We are going to download the package list from our repositories and install PhpMyAdmin
$sudo apt-get update
$sudo apt-get install phpmyadmin -y
- The installer will ask you which platform you are using. You should choose Apache if that is your platform, otherwise Nginx.
- Select yes to dbconfig-common
- You will be prompted for your database password (that is your Mysql password)
- You will then be asked to set a new password for PhpMyAdmin root user
PhpMyadmin need the mcrypt module to be enabled, so to enable the module you should run this command in the terminal.
$sudo php5enmod mcrypt
after the mcrypt module is enabled you need to restart your Apache server
$sudo service apache2 restart
Step 2. Access PhpMyAdmin
By now everything should be installed and up and running. Open your browser and type https://you_ip_address_or_domain/phpmyadmin
The site you are entering should look like this
You can login with:
- Username : root
- Password : The one you created in the installation
If you have access to the server outside of a local network I will strongly recommend that you secure your PhpMyAdmin instance. You can see how you can secure your PhpMyAdmin application here.