Differences

This shows you the differences between two versions of the page.

--- deb11:phpmyadmin [2022/09/26 11:14] – Bernard Condrau
+++ deb11:phpmyadmin [2024/04/25 15:33] (current) – [Configuration] Bernard Condrau
@@ Line 1: / Line 1: @@
 ====== phpMyAdmin ======
-Debian 10/11, other than Debian 9, require manual installation of phpmyadmin, phpmyadmin has been removed from Debian's repositories.
 ===== Installation =====
@@ Line 7: / Line 6: @@
 sudo mv phpMyAdmin-5.2.0-english/ /home/user/html/phpMyAdmin
 $ sudo chown -R www-data:www-data /home/user/html/phpMyAdmin</code>
-  * Up to Debian 9, and in other distributions, phpMyAdmin could be installed via the package manager. Debian 10 dropped the support through the package manager.
+  - To upgrade to a newer version simply download the new version and extract it to the same folder. Files created by the user will remain the same, e.g. ''apache.conf'', ''config.inc.php'', and ''htpasswd.setup''.
+  * __Note__: up to Debian 9, and in other distributions, phpMyAdmin could be installed via the package manager. Debian 10 dropped support to install through the package manager.
 ===== Configuration =====
   - We will not use any of the standard path used in Debian versions up to 9 or in other distributions. All files related to phpMyAdmin will remain in the custom path where we moved the downloaded files which is the easiest way for maintenance and later version upgrades (''/home/user/html/phpMyAdmin'').
-  - Make a new directory for phpMyAdmin to store its temporary files:<code>sudo mkdir -m770 /home/user/html/phpMyAdmin/tmp</code>
+  - Make a new directory for phpMyAdmin to store its temporary files:<code>$ sudo mkdir -m770 /home/user/html/phpMyAdmin/tmp</code>
   - Copy ''config.sample.inc.php'' to ''config.inc.php'' and edit as follows
     - Use the [[https://phpsolved.com/phpmyadmin-blowfish-secret-generator/?g=6330fef62b5a1|phpMyAdmin blowfish secret generator]] to create a new secret passphrase for cookie authentication:<code>$ sudo vim /home/user/html/phpMyAdmin/config.inc.php
@@ Line 84: / Line 84: @@
 MariaDB [(none)]> FLUSH PRIVILEGES;
 MariaDB [(none)]> exit</code>
+  - Make sure permissions are set to traverse directories, particularly ''/home/user/html/'' and ''/home/user/www/''
 ===== Run phpMyAdmin =====
   - Access phpMyAdmin by appending ''/phpmyadmin'' to any website url hosted on the same server.
@@ Line 93: / Line 93: @@
   * [[https://www.how2shout.com/linux/how-to-install-phpmyadmin-on-debian-11-bullseye-apache/|How to Install phpMyAdmin on Debian 11 Bullseye (Apache)]]
   * [[https://www.howtoforge.com/how-to-install-and-secure-phpmyadmin-on-debian-11/#install-and-configure-phpmyadmin|How to Install and Secure phpMyAdmin on Debian 11]]
+  * [[https://docs.phpmyadmin.net/en/latest/config.html|phpMyAdmin Configuration]]

Differences

Know How