create, copy, rename, alter and drop databases Nginx is restarted when the configuration is done: root computer :~$ systemctl reload nginx.This package allows administering of MySQL or MariaDB with a web interface. The virtual server is enabled by creating a symbolic link to its configuration file in the sites-enabled directory: root computer :~$ ln -symbolic /etc/nginx/sites-available/ /etc/nginx/sites-enabled/ Server reinitiation The following will prevent permission errors in the log files: root computer :~$ chmod 0755 /var/lib/phpmyadmin/ root computer :~$ chmod 0664 /var/lib/phpmyadmin/blowfish_ root computer :~$ chmod 0664 /var/lib/phpmyadmin/ Configuration enablement The log directory should be protected: root computer :~$ chown -recursive nginx:adm /var/log/nginx/ root computer :~$ chmod -recursive 0750 /var/log/nginx/ The configuration directory should be protected: root computer :~$ chown -recursive root:adm /etc/phpmyadmin/ root computer :~$ chmod -recursive 0775 /etc/phpmyadmin/ Mysql> GRANT ALL PRIVILEGES ON *.* TO WITH GRANT OPTION Log into MySQL as root: root computer :~$ mysql -user='root' -passwordĬreate a MySQL user: mysql> CREATE USER IDENTIFIED BY '' A new MySQL user can be created with all privileges granted and remote access. It may be impossible to log into phpMyAdmin as the root MySQL user. The file contains a virtual server declaration: serverĪccess_log /var/log/nginx/ Įrror_log /var/log/nginx/.log įastcgi_pass unix:/run/php/

The necessary files are temporarily moved so that the directory can be cleared and are then moved back: root computer :~$ mv /etc/phpmyadmin/ /tmp/ root computer :~$ mv /etc/phpmyadmin/config-db.php /tmp/ root computer :~$ rm -recursive /etc/phpmyadmin/* root computer :~$ mv /tmp/ /etc/phpmyadmin/ root computer :~$ mv /tmp/config-db.php /etc/phpmyadmin/Ī file is created to contain the configuration for the virtual server: root computer :~$ touch /etc/nginx/sites-available/ There is a lot of clutter in the configuration directory. Whether to create the phpMyAdmin database: Yes.PhpMyAdmin can be installed from the official Debian repository using APT: root computer :~# apt -assume-yes install phpmyadminĭuring the installation the user will be prompted for the following information:

Debian install phpmyadmin