NGINX + Apache + MySQL + PHP + PHP-FPM + PHPMyAdmin на Ubuntu

 1. Обновляем Ubuntu:

apt-get update && apt-get upgrade

2. Устанавливаем NGINX

apt-get install nginx

nano vi /etc/nginx/nginx.conf   конфигурация

systemctl restart nginx

systemctl status nginx

3. Установка PHP и PHP-FPM

apt-get install php php7.4-fpm

systemctl enable php7.4-fpm

4. Настройка связки NGINX + PHP

nano /etc/nginx/sites-enabled/default

systemctl restart php7.4-fpm

5. Установка MySQL

apt install mysql-server 

mysqladmin -p -u root version

apt install phpmyadmin

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

Решение проблемы с ошибкой #1698 - Access denied for user ‘root’@’localhost’

Создание нового пользователя для работы с MySQL через phpMyAdmin

sudo mysql --user=root mysql

CREATE USER 'phpmyadmin'@'localhost' IDENTIFIED BY 'some_pass';
GRANT ALL PRIVILEGES ON *.* TO 'phpmyadmin'@'localhost' WITH GRANT OPTION;
FLUSH PRIVILEGES;

sudo mysql

mysql> use mysql;

mysql> SELECT user,authentication_string,plugin,host FROM mysql.user;

# enable password login

mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH caching_sha2_password BY 'password';

mysql> FLUSH PRIVILEGES;

mysql> exit;

# should be able to login with password now

mysql -u root -p

Enter password:

sudo mysql_secure_installation