Install phpMyAdmin on Debian, Ubuntu & Mint with Apache Web Server

Installing phpMyAdmin in Ubuntu 14.04 / Debian 7.6/ Linux Mint 17

Follow the below steps to install phpMyAdmin to above listed Linux distribution.

phpMyAdmin is a free opensource software which helps user to manage/administrate of MySQL database in Web. It supports MySQL, MariaDB and Drizzle.

phpMyAdmin Features

  • Web based Interface
  • Most of MySQL features are supported
  • Browse/create/modify/Drop databases, tables
  • Execute & Edit SOL-statement
  • Manage MySQL users and privileges
  • Manage stored procedures and triggers
  • Import/Export data from CSV and SQL
  • Export data to various formats such as CSV, SQL, XML, PDF, etc,..
  • Administering multiple servers
  • For more details about Features, visit phpMyAdmin official Features page
  • phpMyAdmin home page

1) Update your system upto date

Use the below commands to keep your system upto date.

[email protected]:~$ sudo apt-get update && upgrade

2) phpMyAdmin installation

Use the below command to install phpMyAdmin.

[email protected]:~$ sudo apt-get install phpMyAdmin

3) Web Server Selection

Use UP/DOWN arrow mark to Choose your Web Server then hit Space Bar to toggle, then press Tab and hit Space Bar to move forward.
phpmyadmin-installation-and-configuration-in-linux-3

4) Configuring Database for phpMyAdmin

By default it is highlighting Yes to configure new database for phpMyAdmin, then hit Space Bar to move forward.
phpmyadmin-installation-and-configuration-in-linux-4

5) Creating Database for phpMyAdmin

Enter your MySQL root Password to create a new database for phpMyAdmin, then hit Space Bar to move forward.
phpmyadmin-installation-and-configuration-in-linux-5

6) Setting up phpMyAdmin password

Create the password for phpMyAdmin to access over the web, then hit Space Bar to move forward.
phpmyadmin-installation-and-configuration-in-linux-6

7) Confirming phpMyAdmin password

Re-Enter the password once again to confirm the phpMyAdmin password, then hit Space Bar to move forward.
phpmyadmin-installation-and-configuration-in-linux-7

8) Accessing phpMyAdmin

Open your web browser and navigate to http://localhost/phpmyadmin or http://your-server-ip-address/phpmyadmin or http://127.0.0.1/phpmyadmin and Enter your database password to access it.
phpmyadmin-installation-and-configuration-in-linux-8
Now, i can manage all my MySQL databases using phpMyAdmin.
phpmyadmin-installation-and-configuration-in-linux-8a
We are preparing all articles in-depth to understand by all level/stage Linux administrators. If the article is useful for you, then please spend less than a minute to share your valuable comments in our commenting section.

Please stay tune with us…Good Luck.

Magesh Maruthamuthu

Love to play with all Linux distribution

You may also like...