Install LAMP stack on Ubuntu/Debian

Install Apache2, MySQL and phpMyAdmin on a Linux server:

Update System

sudo apt update && sudo apt upgrade -y; apt install sudo

Install Apache2

sudo apt install apache2 -y

Fedora/CentOS/RHEL-based systems:

sudo yum install httpd

Enable and start the Apache service:

sudo systemctl enable apache2
sudo systemctl start apache2

Install MySQL Server

sudo apt install mysql-server -y

Secure the MySQL installation:

sudo mysql_secure_installation

Install PHP and Required Extensions

sudo apt install php libapache2-mod-php php-mysql php-mbstring php-zip php-gd php-json php-curl -y

Install phpMyAdmin

sudo apt install phpmyadmin -y

Enable phpMyAdmin in Apache

sudo ln -s /usr/share/phpmyadmin /var/www/html/phpmyadmin

Restart Apache:

sudo systemctl restart apache2

Solution: Change the authentication plugin for the root user to mysql_native_password

• Connect to MySQL as root:

sudo mysql -u root -p

Execute the following SQL commands:

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'root_password';
FLUSH PRIVILEGES;

Replace root_password with your actual root password.

• Exit the MySQL client:

exit

• Restart the MySQL service:

sudo systemctl restart mysql