Install phpmyamin in Raspberry Pi

First, install MySQL which is a free opensource database system.

sudo apt install mysql-server php-mysql

The PHPMyAdmin installation is pretty quick and easy, we simply have to use the packet manager with this command :

sudo apt install phpmyadmin

but here we're going to install phpmyadmin in a another way. go to phpmyadmin website then download as zip. unzip the copy to var/www/html path.

After install mysql go cmd to set new password for root

sudo mysql_secure_installation   

 [to set new pass type none then entry new password]

To login mysql go cmd and type

sudo mysql -p -u root 

Then add new super user to access phpmyadmin

set password for user esteemsoft

CREATE USER ‘esteemsoft’@’%’ IDENTIFIED BY ‘password’ 

GRANT ALL PRIVILEGES ON *.* TO  ‘esteemsoft’@’%’ WITH GRANT OPTION;

Done!!! now go to localhost/phpmyadmin and enjoy....