phpMyAdmin Logo

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:

myserver.com/phpmyadmin

phpMyAdmin - Login

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:

phpMyAdmin - interface

Conclusion

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.

RECOMMENDED:

1. How to create, backup or remove MySQL Databases in cPanel

2. How To: Easy Moving a WordPress Website

NO COMMENTS

Leave a Reply