Trace: • phpmyadmin

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
deb11:phpmyadmin [2022/09/26 11:15] – Bernard Condraudeb11:phpmyadmin [2025/11/22 00:11] (current) – [Installation] Bernard Condrau
Line 1: Line 1:
 ====== phpMyAdmin ====== ====== phpMyAdmin ======
-Debian 10/11, other than Debian 9, require manual installation of phpmyadmin, phpmyadmin has been removed from Debian's repositories. 
  
 ===== Installation ===== ===== Installation =====
-  - Download the latest [[https://www.phpmyadmin.net/downloads/|phpMyAdmin]] from the Downloads page, scroll down to the table with download links for the latest stable release, and copy the download link ending in tar.gz:<code>$ wget https://files.phpmyadmin.net/phpMyAdmin/5.2.0/phpMyAdmin-5.2.0-english.tar.gz</code> +  - Download the latest [[https://www.phpmyadmin.net/downloads/|phpMyAdmin]] from the Downloads page, scroll down to the table with download links for the latest stable release, and copy the download link ending in tar.gz:<code>$ wget https://files.phpmyadmin.net/phpMyAdmin/5.2.3/phpMyAdmin-5.2.3-english.tar.gz</code> 
-  - Unzip the tarball, then move the folder to a local folder outside of apache's document root (we will create a path alias in phpMyAdmin's ''apache.conf'' later) and set ownership:<code>$ tar xvf phpMyAdmin-5.2.0-english.tar.gz +  - Unzip the tarball, then move the folder to a local folder outside of apache's document root (we will create a path alias in phpMyAdmin's ''apache.conf'' later) and set ownership:<code>$ tar xvf phpMyAdmin-5.2.3-english.tar.gz 
-sudo mv phpMyAdmin-5.2.0-english/ /home/user/html/phpMyAdmin+sudo mv phpMyAdmin-5.2.3-english/ /home/user/html/phpMyAdmin
 $ sudo chown -R www-data:www-data /home/user/html/phpMyAdmin</code> $ 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 ===== ===== Configuration =====
Line 81: Line 81:
 $ sudo service apache2 restart</code> $ sudo service apache2 restart</code>
   - Create a regular MariaDB user for the purpose of managing databases through phpMyAdmin, if you haven't done that yet when configuring MariaDB. You could create a user that has privileges to all tables within the database, as well as the power to add, change, and remove user privileges, with this command. Whatever privileges you assign to this user, be sure to give it a strong password as well:<code>$ sudo mariadb   - Create a regular MariaDB user for the purpose of managing databases through phpMyAdmin, if you haven't done that yet when configuring MariaDB. You could create a user that has privileges to all tables within the database, as well as the power to add, change, and remove user privileges, with this command. Whatever privileges you assign to this user, be sure to give it a strong password as well:<code>$ sudo mariadb
-MariaDB [(none)]> CREATE USER 'user'@'localhost' IDENTIFIED BY 'password' WITH GRANT OPTION;+MariaDB [(none)]> CREATE USER 'user'@'localhost' IDENTIFIED BY 'password'; 
 +MariaDB [(none)]> GRANT ALL PRIVILEGES ON *.* TO 'user'@'hostname';
 MariaDB [(none)]> FLUSH PRIVILEGES; MariaDB [(none)]> FLUSH PRIVILEGES;
 MariaDB [(none)]> exit</code> MariaDB [(none)]> exit</code>
 +  - Make sure permissions are set to traverse directories, particularly ''/home/user/html/'' and ''/home/user/www/''
 ===== Run phpMyAdmin ===== ===== Run phpMyAdmin =====
   - Access phpMyAdmin by appending ''/phpmyadmin'' to any website url hosted on the same server.   - Access phpMyAdmin by appending ''/phpmyadmin'' to any website url hosted on the same server.
Line 93: Line 94:
   * [[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.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://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]]
 +  * [[https://www.digitalocean.com/community/tutorials/how-to-install-and-secure-phpmyadmin-on-debian-9|How To Install and Secure phpMyAdmin on Debian 9]]
 +  * [[https://www.digitalocean.com/community/tutorials/how-to-install-phpmyadmin-from-source-debian-10|How To Install phpMyAdmin From Source on Debian 10]]
 +  * [[https://computingforgeeks.com/install-phpmyadmin-with-apache-on-debian-10-buster/|How To Install phpMyAdmin with Apache on Debian 10]]
 +  * [[https://devanswers.co/problem-php-7-2-phpmyadmin-warning-in-librariessql-count/|Problem with phpMyAdmin and PHP 7.2]]
 +  * [[https://devanswers.co/manually-upgrade-phpmyadmin/|How to Manually Upgrade phpMyAdmin]]
 +  * [[https://www.phpmyadmin.net/downloads/|Download phpMyAdmin]]
 +  * [[https://www.itaewonpool.org/phpmyadmin/doc/html/faq.html#faq1-16|phpMyAdmin trouble shooting]]
 +

Know How

© 2007-2025 Bernard Condrau - Powered by DokuWiki