Install phpMyAdmin on Ubuntu 16.04


Install phpMyAdmin on Ubuntu 16.04

We’ll show you, how to install phpMyAdmin on Ubuntu 16.04.  phpMyAdmin is one of the most popular and widely used web-based database management tools. It a free and open source PHP application that allows the users to manage single or multiple SQL database servers locally or on a remote server using a web browser (GUI). phpMyAdmin is very handy and useful. We can easily create, rename, delete and edit databases, tables or fields, execute SQL commands, import and export tables, create and modify users, etc., all via an easy-to-use GUI. Installing phpMyAdmin on an Ubuntu 16.04 is an easy task if you carefully follow the steps bellow.

1. Login via SSH

Login to your Ubuntu 16.04 VPS via SSH as user root

ssh [email protected]_address

and make sure that you have the latest version of all installed packages

apt-get update && apt-get upgrade

2. Install LAMP Stack – (Linux, Apache, MariaDB/MySQL, PHP)

phpMyAdmin requires a LAMP (Linux, Apache, MariaDB/MySQL, PHP) stack. If you don’t have it already installed on your server, you can do it by executing the following commands

apt-get install apache2 php mysql-server

3. Install phpMyAdmin on Ubuntu 16.04

Once Apache, PHP and MySQL are installed, we can go ahead and install phpMyAdmin. The package is included in the official Ubuntu 16.04 repository and it can be easily installed with the command below

apt-get install phpmyadmin

phpMyAdmin will be installed along with its dependencies and all necessary PHP modules.

When you will be prompted to select a web server to configure, hit the space bar to select Apache2 and Enter to confirm and continue

lqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqu Configuring phpmyadmin tqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqq
x Please choose the web server that should be automatically configured to run phpMyAdmin.  x
x                                                                                          x
x Web server to reconfigure automatically:                                                 x
x                                                                                          x
x    [ ] apache2                                                                           x
x    [ ] lighttpd                                                                          x
x                                                                                          x
x                                                                                          x
x                                          <Ok>                                            x
x                                                                                          x
mqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj

On the next screen, select YES to configure a database for phpMyAdmin with dbconfig-common

qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqq Configuring phpmyadmin qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqq
x                                                                                                           x
x The phpmyadmin package must have a database installed and configured before it can be used.               x
x  This can be optionally handled with dbconfig-common.                                                     x
x                                                                                                           x
x If you are an advanced database administrator and know that you want to perform this configuration        x
x  manually, or if your database has already been installed and configured, you should refuse this option   x
x Details on what needs to be done should most likely be provided in /usr/share/doc/phpmyadmin.             x
x                                                                                                           x
x Otherwise, you should probably choose this option.                                                        x
x                                                                                                           x
x Configure database for phpmyadmin with dbconfig-common?                                                   x
x                                                                                                           x
x                             <Yes>                         <No>                                            x
x                                                                                                           x
mqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqq

4. Set the Password for the phpMyAdmin User

and finally set a password for the ‘phpmyadmin’ user in MySQL

With this step, the installation of phpMyAdmin is completed.

5. Test and Verify phpMyAdmin Installation on Ubuntu 16.04

You can access it at http://yourIPaddress/phpmyadmin and login with your MySQL username and password.

How To Install phpMyAdmin on Ubuntu 16.04

 


Install phpMyAdmin on Ubuntu 16.04

Of course, you don’t have to install phpMyAdmin on Ubuntu 16.04 if you use one of our Optimized phpMyAdmin Hosting services, in which case you can simply ask our expert Linux admins to install phpMyAdmin on Ubuntu 16.04 for you. They are available 24×7 and will take care of your request immediately.

PS. If you liked this post, on how to install phpMyAdmin on Ubuntu 16.04, please share it with your friends on the social networks using the buttons below or simply leave a comment in the comments section. Thanks.

Tutorials
How to install Drupal 7 on Ubuntu 14.04
Tutorials
Install the Sails.js framework on an Ubuntu VPS
Tutorials
Install LiteCart on Ubuntu 14.04 with Nginx, PHP-FPM and MySQL
  • raai

    raairaai

    Author Reply

    Thanks for this great post. i really appreciate your blog.
    The best place for learning.


  • anonymous

    anonymousanonymous

    Author Reply

    Yes thanks for this post. Really helped a lot in need.


  • Jackey Wu

    Jackey WuJackey Wu

    Author Reply

    How to login as root in phpmyadmin? I can’t log in.


  • admin

    adminadmin

    Author Reply

    Default dbuser is phpmyadmin instead of root.


  • Manu

    ManuManu

    Author Reply

    Thank you bro …Its helped lot