Install phpmyadmin in Ubuntu 19.10


This guide will help you with the installation of phpmyadmin on Ubuntu 19.10. If you’re using Ubuntu 19.10 or above, you’ll notice that you cannot install phpmyadmin from apt becasue 19.10 does not come with this package. You’ll get following error

Package 'phpmyadmin' has no installation candidate

In this guide I’m going to tell you how you can install phpmyadmin within your Ubuntu 19.10 system using composer.

Make sure you’ve lamp stack setup in your system. You can follow this guide here to Install LAMP stack in your Ubuntu System

How to install Phpmyadmin in Ubuntu Linux ?

STEP 1 – In order to install phpmyadmin in ubuntu 19.10 we’ll first add the phpmyadmin ppa to our ubuntu base. In order to do that run the following command –

STEP 2 – Now, we’ll update our ubuntu libraries with the following command –

STEP 3 – Now we can install phpmyadmin with the following command

STEP 4 – To configure phpmyadmin to work with apache, in the following screen that appears choose apache2 by pressing space and use tab key to move to ok button and hit enter.

install phpmyadmin on ubuntu 20.04

STEP 5 – Set MySQL password for your user and then confirm password.

This will install phpmyadmin on your system. Now you can access it using


in your browser

STEP 6 – Until now, we’ve successfully installed phpmyadmin on our system but, id your mysql version is 8.*, you’ll not be able to login with phpmyadmin and you may get following error –

The server requested authentication method unknown to the client [caching_sha2_password]

This is because the MySQL 8.0.11 is using caching_sha2_password as default authentication method which is not understandabe by phpmyadmin, so we’ll create a new user in MySQL. Login to MySQL from terminal –

Now your prompt will change to mysql > . Run the following query to create a new user for phpmyadmin –

Now you can login to phpmyadmin using above credentials i.e. –

username - xyz

password - passw0rd

But you’ll not be able create any databases with this user as we’ve not provided any privileges to this user. Then use the following query to grant privileges to the user ‘xyz’ –

Now you can access all the databases through phpmyadmin. If you’re facing any issue please comment below, I’ll try to solve your problem.

Also ReadBest download mangers for Ubuntu

Author: Deepak Kumar

This is Deepak Kumar, founder of True Infosystems and of-course the chief content creator at Started my carrier as a Freelancer and now a top-rated Freelancer at Upwork, delivered over 200 successful projects with highly positive user ratings and counting.

Leave a Reply

Your email address will not be published. Required fields are marked *