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.

4) Configuring Database for phpMyAdmin

By default it is highlighting Yes to configure new database for phpMyAdmin, then hit Space Bar to move forward.

5) Creating Database for phpMyAdmin

Enter your MySQL root Password to create a new database for phpMyAdmin, then hit Space Bar to move forward.

6) Setting up phpMyAdmin password

Create the password for phpMyAdmin to access over the web, then hit Space Bar to move forward.

7) Confirming phpMyAdmin password

Re-Enter the password once again to confirm the phpMyAdmin password, then hit Space Bar to move forward.

8) Accessing phpMyAdmin

Open your web browser and navigate to http://localhost/phpmyadmin or http://your-server-ip-address/phpmyadmin or and Enter your database password to access it.
Now, i can manage all my MySQL databases using phpMyAdmin.
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...