Install phpMyAdmin on Ubuntu 14.10

0

phpMyAdmin
phpMyaAdmin is the web based administration tool for managing the MySQL, MariaDB and Drizzle servers, it helps in performing databases activities such as creating, deleting ,querying , tables, columns, relations, indexes, users, permissions, etc. This guide will help you to install phpMyAdmin on Ubuntu 14.10.

Before installing phpMyAdmin, you can have AMP installed on the server. Here is the tutorial on Installing LAMP on Ubuntu 14.10.

Installing phpMyAdmin:

I am assuming that you have completed the previous step, Install phpMyAdmin using the following command.

raj@server:~$ sudo apt-get install libapache2-mod-auth-mysql php5-mysql phpmyadmin

Installation will prompt you to select the web server for automatic configuration. Use space to select the web server type and then press Enter.

Ubuntu 14.10 - phpMyAdmin - Autoconfiguration
Ubuntu 14.10 – phpMyAdmin – Autoconfiguration

Next screen will prompt you for configuring database called db-common for phpMyAdmin. Use the tab key to select yes and Press Enter.

Ubuntu 14.10 - phpMyAdmin - Configure Database
Ubuntu 14.10 – phpMyAdmin – Configure Database

Next it will prompt you to enter the password for MySQL root user, please enter the MySQL root password.

Ubuntu 14.10 - phpMyAdmin - Enter MySQL root password
Ubuntu 14.10 – phpMyAdmin – Enter MySQL root password

It will prompt you to type the password for MySQL application password for phpmyadmin.if you left it blank, a random password will be generated. Type the password of your wish and press Enter.

Ubuntu 14.10 - phpMyAdmin - Application Password for phpmyadmin
Ubuntu 14.10 – phpMyAdmin – Application Password for phpmyadmin

Confirm your password in the next screen.

Ubuntu 14.10 - phpMyAdmin - Re Enter Application Password for phpmyadmin
Ubuntu 14.10 – phpMyAdmin – Re Enter Application Password for phpmyadmin

Accessing phpMyAdmin:

Now access the phpPgAdmin from the browser, url will be http://your-ip-address/phpMyAdmin.
Login by using root or admin user.

Ubuntu 14.10 - phpMyAdmin - Login Page
Ubuntu 14.10 – phpMyAdmin – Login Page

You will get the database page.

Ubuntu 14.10 - phpMyAdmin - Main Page
Ubuntu 14.10 – phpMyAdmin – Main Page

That’s All. Hope this helped you, we welcome your comments.

You might also like