phpmyadmin_installation(lamp)

For understand every steps about installation here i have use digitalocean documentaion.

https://www.digitalocean.com/community/tutorials/how-to-install-and-secure-phpmyadmin-on-ubuntu-22-04

Step 1 — Installing Apache and Updating the Firewall:-

if we Change apache2 port :- follow some steps

change Listen 80 () to another Listen port(ex. 8080)
change inbound rule
we can see this using - Ip:8080 in broser

if our apache2 not connect then :-

sudo ufw status
sudo ufw enable
sudo ufw allow 8080/tcp (Allow Necessary Ports)

sudo ufw allow 80/tcp sudo ufw allow 443/tcp

sudo ufw enable
sudo ufw status

Step 2 — Installing MySQL

To check the port on which MySQL is running in Ubuntu using the command line :-

sudo netstat -tlnp | grep mysql

Step 3 — Installing PHP

php -v (check version of php)

Step 4 — Installing phpMyAdmin

steps :-

set phpmyadmin password - phpmyadmin
select - retry and OK (database installation)
select - TCP/IP (connection method)
select - Localhost ( Host name)
3306 - (MySql port )
select - default ( Authentication plugin )
give name of MySQL database - phpmyadmin
give username of MySQL for phpmyadmin - root (those user/root you create mySQL installation time)
give password of MySQL user - Admin
retype Mysql user password and select OK
check browser:- IP:8080/phpmyadmin
give username = root and password = Admin

Once we enter root and password then we can also change the phpmyadmin password or if our phpmyadmin user not connect to data base then we can create it from root user database and also give priviledge then it work properly.

if some problem in phpmyadmin install then we can remove and purge phpmyadmin :-

sudo apt purge phpmyadmin php-mbstring php-zip php-gd php-json php-curl

This worked for me in ubuntu 20.04. I upgraded my php version from php7.4 to php8.1, after that I faced this error in phpmaydmin. Then I added this line $cfg['SendErrorReports'] = 'never'; to end of this file /etc/phpmyadmin/config.inc.php. and restart apache2.