How to Install PhpMyAdmin on Debian 11.4.0

To Install PhpMyAdmin On Linux Debian 11.4.0

Introduction:

PhpMyAdmin is a free and open-source administration tool for MySQL and MariaDB. In addition to being a portable web application written primarily in PHP, it has become one of the most popular MySQL administration tools, particularly for web hosting services.

Installation Steps:

Step 1: Check the Version of Debian Linux by using the below command

root@debian:~# lsb_release -a
No LSB modules are available.
Distributor ID: Debian
Description:   Debian GNU/Linux 11 (bullseye)
Release:  11
Codename: bullseye

Step 2: Update server packages to latest version by using the below command

root@debian:~# apt update
Hit:1 http://security.debian.org/debian-security bullseye-security InRelease
Hit:2 http://deb.debian.org/debian bullseye-updates InRelease
Hit:3 http://deb.debian.org/debian bullseye InRelease
Reading package lists... Done
Building dependency tree... Done
Reading state information... Done
All packages are up to date.

Step 3: Install Phpadmin by using the below command

root@debian:~# apt install phpmyadmin -y
Reading package lists... Done
Building dependency tree... Done
Reading state information... Done
The following package was automatically installed and is no longer required:
  libopengl0
Use 'apt autoremove' to remove it.
The following additional packages will be installed:
  php-bz2 php-curl php-gd php-google-recaptcha php-mariadb-mysql-kbs php-mbstring
  php-mysql php-phpmyadmin-motranslator php-phpmyadmin-shapefile
  php-phpmyadmin-sql-parser php-phpseclib php-psr-cache php-psr-container
  php-psr-log php-symfony-cache php-symfony-cache-contracts php-symfony-config
  php-symfony-dependency-injection php-symfony-expression-language
  php-symfony-filesystem php-symfony-service-contracts php-symfony-var-exporter
  php-symfony-yaml php-tcpdf php-twig php-twig-i18n-extension php-xml php-zip
  php7.4-bz2 php7.4-curl php7.4-gd php7.4-mbstring php7.4-mysql php7.4-xml
  php7.4-zip
Suggested packages:
  php-dbase php-libsodium php-mcrypt php-gmp php-symfony-finder
  php-symfony-proxy-manager-bridge php-symfony-console php-imagick php-twig-doc
  php-recode php-gd2 php-pragmarx-google2fa-qrcode php-samyoul-u2f-php-server
Recommended packages:
  php-mcrypt
The following NEW packages will be installed:
  php-bz2 php-curl php-gd php-google-recaptcha php-mariadb-mysql-kbs php-mbstring
  php-mysql php-phpmyadmin-motranslator php-phpmyadmin-shapefile
  php-phpmyadmin-sql-parser php-phpseclib php-psr-cache php-psr-container
  php-psr-log php-symfony-cache php-symfony-cache-contracts php-symfony-config
  php-symfony-dependency-injection php-symfony-expression-language
  php-symfony-filesystem php-symfony-service-contracts php-symfony-var-exporter
  php-symfony-yaml php-tcpdf php-twig php-twig-i18n-extension php-xml php-zip
  php7.4-bz2 php7.4-curl php7.4-gd php7.4-mbstring php7.4-mysql php7.4-xml
  php7.4-zip phpmyadmin
0 upgraded, 36 newly installed, 0 to remove and 0 not upgraded.

root@debian:~# mysql
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 55
Server version: 10.5.19-MariaDB-0+deb11u2 Debian 11

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]>

MariaDB [(none)]> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| phpmyadmin         |
+--------------------+
4 rows in set (0.001 sec)

MariaDB [(none)]> use phpmyadmin;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed

MariaDB [phpmyadmin]> create user user@localhost identified by 'Linuxc#4';
Query OK, 0 rows affected (0.001 sec)

MariaDB [phpmyadmin]> grant all on phpmyadmin.* to user@localhost;
Query OK, 0 rows affected (0.001 sec)

MariaDB [phpmyadmin]> flush privileges;
Query OK, 0 rows affected (0.001 sec)

MariaDB [phpmyadmin]> exit
Bye

root@debian:~# systemctl restart apache2

root@debian:~# apt install php7.4-mysqli
Reading package lists... Done
Building dependency tree... Done
Reading state information... Done
Note, selecting 'php7.4-mysql' instead of 'php7.4-mysqli'
php7.4-mysql is already the newest version (7.4.33-1+deb11u4).
php7.4-mysql set to manually installed.
The following package was automatically installed and is no longer required:
  libopengl0
Use 'apt autoremove' to remove it.
0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.

root@debian:~# systemctl restart apache2