how to install phpmyadmin in ubuntu

Install PhpMyAdmin

What Is PhpMyAdmin

phpMyAdmin is a free and open source administration tool for MySQL and MariaDB. As a portable web application written primarily in PHP, it has become one of the most popular MySQL administration tools, especially for web hosting services.

Requirement Of Installing Phpmyadmin On Ubuntu

Before installing phpMyAdmin, we need to meet some basic requirements:

• Apache    
• Mysql
• Php

Step 1 :- Install phpmyadmin

# sudo apt-get update

# sudo apt-get install phpmyadmin

step 2 :- Configure Phpmyadmin

After installation of phpmyadmin, you will be show a package configuration screen.
select apache  and press enter .

Select "Yes" and then Enter.

Now it will show password screen, here enter Database Administrator Password.

Enter the password for phpmyadmin application.

Again confirm the phpmyadmin application password.

Step 3 :-  Add phpmyadmin support apache config line in apache2.conf file.

Add this one line  "Include /etc/phpmyadmin/apache.conf"  in /etc/apache2/apache2.conf  end of the file.

# vim /etc/apache2/apache2.conf

Step 4 :- Access Phpmyadmin in browser.

Go to your browser url box write :- http://your_server_ip/phpmyadmin

• If you are getting Error during making database connection on adminser or phpmyadmin
• So, kindly add below command on mysql configuration file then restart database.

Error : The server requested authentication method unknown to the client

$ vim /etc/mysql/mysql.conf.d/mysqld.cnf

default_authentication_plugin= mysql_native_password