Install PHPMyAdmin on Debian 11īy default, it is included in the official Debian 11 repositories. From there, we can then access it with a web device such as a computer, tablet, or mobile phone. In addition to this, we are talking about an open-source project with which we can examine its source code and even modify it.Īnother advantage of using PHPMyAdmin is that as it is a project created with PHP, the only thing we need is an operating system with a web server installed. Nginx is restarted when the configuration is done: root computer :~$ systemctl reload nginx.Therefore, with PHPMyAdmin we can quickly query our data and other options quickly and easily. 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:
0 kommentar(er)
