Skip to content

Instantly share code, notes, and snippets.

@qa1
Created October 8, 2021 19:21
Show Gist options
  • Save qa1/b7c11e0ca065f648e715f8b4c046281e to your computer and use it in GitHub Desktop.
Save qa1/b7c11e0ca065f648e715f8b4c046281e to your computer and use it in GitHub Desktop.
sudo apt-get remove --purge mysql\*
sudo apt install mysql-server mysql-client
sudo mysql
> UNINSTALL COMPONENT "file://component_validate_password";
sudo phpenmod mbstring
sudo apt install php7.4 php7.4-fpm php7.4-mysql php7.4-cgi php7.4-cli php7.4-common
sudo apt install phpmyadmin php-mbstring php-zip php-gd php-json php-curl
sudo mysql
> SELECT user,authentication_string,plugin,host FROM mysql.user;
> ALTER USER 'root'@'localhost' IDENTIFIED WITH caching_sha2_password BY 'password';
Nginx
# phpMyAdmin:
location /phpmyadmin {
root /usr/share;
index index.php;
}
# PHP files for phpMyAdmin:
location ~ ^/phpmyadmin(.+\.php)$ {
root /usr/share;
index index.php;
#fastcgi_read_timeout 300;
include snippets/fastcgi-php.conf;
fastcgi_pass unix:/run/php/php7.4-fpm.sock;
}
# PHP files for the main application:
location ~ \.php$ {
fastcgi_read_timeout 300;
include snippets/fastcgi-php.conf;
fastcgi_pass unix:/run/php/php7.4-fpm.sock;
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment