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 –

sudo add-apt-repository ppa:phpmyadmin/ppa
  

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

sudo apt update

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

sudo apt install phpmyadmin

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.

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

http://localhost/phpmyadmin 

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 –

sudo mysql

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

CREATE USER xyz@localhost IDENTIFIED WITH mysql_native_password BY 'passw0rd'

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’ –

GRANT ALL PRIVILEGES ON *.* TO xyz@localhost

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 Read – Best download mangers for Ubuntu