Many users use database management like MySQL. Besides this you may need the phpMyAdmin which can interact with MySQL through web interface.
In this guide I will show you how to install and use phpMyAdmin on Ubuntu.
RECOMMENDED: How to Install WordPress Manually
1. Install phpMyAdmin
To get started, we can easy install phpMyAdmin from the Ubuntu repositories. So, open the Terminal from Ubuntu and type the following commands:
sudo apt-get update
sudo apt-get install phpmyadmin
The installation can take from some seconds to some minutes. Also pay attention as when prompt appears you will have to hit “SPACE” to select Apache, if not, the installer will not move the necessary files during installation. So use “SPACE”, “TAB” and “ENTER”
Choose apache2, then select yes to use the dbconfig-common to set up the database. Also choose a password for phpMyAdmin.
RECOMMENDED: What to Choose? Linux vs. Windows Hosting
2. Enable php5-mcrypt
After this, we will have to enable the php5-mcrypt extension. In terminal type the following lines:
sudo php5enmod mcrypt
sudo service apache2 restart
3. Access phpMyAdmin
Now we can easy access the phpMyAdmin interface by visiting the following address on our computer:
Local Ip address/phpmyadmin
Or, if we installed phpMyAdmin on a server, we will have to visit the server’s domain name or public IP, for example:
Now you can log into the phpMyAdmin by using the root username and the administrative password you have set when you installed MySQL.
RECOMMENDED: WordPress Backup to Dropbox
When you log in, you’ll see the user interface, which will look something like this:
Now you have installed phpMyAdmin on your Ubuntu. You can use phpMyAdmin to easy create databases, users, tables and other important things.
If you have running website, make sure that you do a backup before changing anything.