How to install phpMyAdmin with PHP8 on Debian 11 (bullseye)
This tutorial shows how to install phpMyAdmin on Debian 11 with Apache2 and PHP8. For administration and management of MySQL and MariaDB databases from web browsers.
On Debian 11, the easiest way to install phpMyAdmin is via the Package Manager, with
apt install phpmyadminbut this is no longer up-to-date since php 8 is provided.
Since Debian 11 installs from the default repository, phpMyAdmin is provided for PHP 7.4, but if requires a newer PHP version, i.e. for current CMS such as WordPress, where PHP 8 or newer is recommended, phpMyAdmin can be installed manually in just a few steps.
The installation is done here as root by using “su -“, for the packages Apache2, MariaDB and PHP 8.2 provided by DEB.SURY.ORG.
First of all, required service packages are installed.
$ apt install lsb-release apt-transport-https ca-certificates wget gnupg -y
Add the Sury Repository for PHP8 on the system.
$ wget -O /etc/apt/trusted.gpg.d/php.gpg https://packages.sury.org/php/apt.gpg $ echo "deb https://packages.sury.org/php/ $(lsb_release -sc) main" | tee /etc/apt/sources.list.d/php.list
Update the package lists as follows.
$ apt update
If the Apache2 web server is not already installed.
$ apt install apache2 -y
Now install PHP 8.2 with the most important PHP modules.
$ apt install php8.2 php8.2-common php8.2-cli php8.2-curl php8.2-imap php8.2-apcu php8.2-intl php8.2-cgi php8.2-mbstring php8.2-gd php8.2-mysql php8.2-opcache php8.2-bcmath php8.2-xml php8.2-xsl php8.2-zip php8.2-bz2 libapache2-mod-php8.2 -y
Update the packages as follows.
$ apt update && apt upgrade -y $ [ -f /var/run/reboot-required ] && reboot -f
The next step is to install the MariaDB server and (MySQL) client.
$ apt install mariadb-server mariadb-client -y
Then complete the configuration of the MariaDB server.
Since the root password for the database is not yet set, press Enter to skip the initial query. Complete the following queries:
- Switch to unix_socket authentication [Y/n] – Enter n to skip.
- Set root password? [Y/n] – Type y and press Enter to create a root password for your database. If you already have a root password, enter n to not change the root password.
- Remove anonymous users? [Y/n] – Type y and press Enter.
- Disallow root login remotely? [Y/n] – Type y and press Enter.
- Remove test database and access to it? [Y/n] – Type y and confirm with Enter.
- Reload privilege tables now? [Y/n] – Type y and confirm with Enter.
MariaDB is now operational.
Just change the directory path.
$ cd /usr/share
To download phpMyAdmin run the command as follows.
$ wget https://www.phpmyadmin.net/downloads/phpMyAdmin-latest-all-languages.zip -O phpmyadmin.zip
Unzip the archive you just downloaded as follows.
$ unzip phpmyadmin.zip
After unzipping, remove the downloaded archive.
$ rm -f phpmyadmin.zip
Then rename the unzipped directory.
$ mv phpMyAdmin-*-all-languages phpmyadmin
And change the permissions to the phpMyAdmin directory.
$ chmod -R 0755 phpmyadmin
Apache2 config for phpMyAdmin
Now create an Apache2 configuration file for phpMyAdmin /etc/apache2/conf-available/phpmyadmin.conf.
Paste the following content into the terminal shell.
$ cat << EOF > /etc/apache2/conf-available/phpmyadmin.conf Alias /phpmyadmin /usr/share/phpmyadmin <Directory /usr/share/phpmyadmin> Options SymLinksIfOwnerMatch DirectoryIndex index.php </Directory> <Directory /usr/share/phpmyadmin/templates> Require all denied </Directory> <Directory /usr/share/phpmyadmin/libraries> Require all denied </Directory> <Directory /usr/share/phpmyadmin/setup/lib> Require all denied </Directory> EOF
Check the new Apache2 configuration you just modified.
$ apachectl -t Syntax OK
Enable the Apache2 configuration file you just created.
$ a2enconf phpmyadmin
And reload the Apache2 web server.
$ systemctl reload apache2
Create the temporary directory that phpMyAdmin needs.
$ mkdir /usr/share/phpmyadmin/tmp/
Now grant the web server user the required owner rights.
$ chown -R www-data:www-data /usr/share/phpmyadmin/tmp/
Up to and including Debian 10 and Ubuntu, password authentication to the MariaDB server is not possible by default for root login (e.g. via phpMyAdmin) for security reasons. On Debian 11, however, this is possible. For Debian 10, the following steps can be performed to allow root login using a password as well.
$ mysql -u root UPDATE mysql.user SET plugin = 'mysql_native_password' WHERE user = 'root' AND plugin = 'unix_socket'; FLUSH PRIVILEGES; Quit
The Apache2 web server with PHP 8, the MariaDB server and phpMyAdmin is now ready to use.
The phpMyAdmin website can be reached by adding /phpmyadmin to the IP address or FQDN in the browser URL.
for example: http://192.168.1.2/phpmyadmin
View and change PHP version
If several PHP versions are installed on the system, an installed PHP version can be activated for the Apache2 web server.
The corresponding module is activated with the Apache helper, with the command a2enmod, and deactivated with a2dismod.
$ a2dismod php7.4 $ a2enmod php8.2 $ systemctl restart apache2
The current PHP version and modules are displayed by creating a php file with the following content. If no other Apache2 site is available, this can be saved as phpinfo.php in the docroot at /usr/share/phpmyadmin.
<?php phpinfo(); ?>
The PHP settings for the Apache2 web server are displayed in tabular form in the web browser. i.e. http://192.168.1.2/phpinfo.php
For productive systems, phpinfo should be removed again.
You might also be interested in the related post here.
We are sorry that this post was not useful for you!
Let us improve this post!
Tell us how we can improve this post?