apt install php-mbstring php8.3-mysqli php8.3-fpm unzip
- CREATE DATABASE phpmyadmin;
- CREATE USER 'phpmyadmin'@'localhost' IDENTIFIED BY '(INSERT PASSWORD)';
- GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP ON
phpmyadmin
.* TOphpmyadmin
@localhost
; - GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP ON
(INSERT DATABASE NAME)
.* TOphpmyadmin
@localhost
;
OR - GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP ON *.* TO
phpmyadmin
@localhost
;
mkdir /etc/nginx/phpMyAdmin;
mkdir /etc/nginx/phpMyAdmin/tmp;
chmod 550 /etc/nginx/phpMyAdmin;
chown root:www-data /etc/nginx/phpMyAdmin;
find /etc/nginx/phpMyAdmin/ -type f -exec chmod 440 {} ;
find /etc/nginx/phpMyAdmin/ -type d -exec chmod 550 {} ;
find /etc/nginx/phpMyAdmin/ -type f -exec chown root:www-data {} ;
find /etc/nginx/phpMyAdmin/ -type d -exec chown root:www-data {} ;
chmod 770 /etc/nginx/phpMyAdmin/tmp;