This tutorial is about How to Run phpMyAdmin Bullseye (Apache) on Debian 11. Recently I updated this tutorial and will try my best so that you understand this guide. I hope you guys like this blog, How to Run phpMyAdmin Bullseye (Apache) on Debian 11. If your answer is yes after reading the article, please share this article with your friends and family to support us.
Check How to Run phpMyAdmin Bullseye (Apache) on Debian 11
In this tutorial, we will tell you the best way to install phpMyAdmin on Debian 11. For those of you who didn’t have the faintest idea, phpMyAdmin is a free, open source, web-based application used to monitor MySQL or Datasets. MariaDB from the web interface. It is written in PHP and is one of the most popular database organization devices used by web facilitation companies to allow budding IT executives to perform dataset exercises.
This article accepts that you have basically essential information about Linux, you figure out how to use the shell, and most of all, you have your site on your own VPS. The installation is very basic and expects you to be running under the root account, on the off chance that you don’t have to add ‘sudo’ to the commands to get root benefits. I will show you little by little installation of phpMyAdmin on Debian 11 (Bullseye).
Install PHPMyAdmin on Debian 11
By default, it is included in the official Debian 11 repositories. So installing it is very easy to do. The problem is that the versions included in the repositories are not always the most up-to-date.
So in this post, we will go through the whole process to get the latest stable version posted on the PHPMyAdmin website.
Install LAMP on Debian 11
Since it is a web application, then it is necessary for our computer to function as a web server. So we need to install LAMP on Debian 11
For that, you must first install Apache on Debian 11 and then MariaDB on Debian 11. With our posts, you will have no problem doing so.
Also, you need to install some PHP modules like
php libapache2-mod-php php-mysql php-mysql php-mbstring php-xml php-zip
Once we have LAMP fully installed, we can continue.
Download and install the latest version of PHPMyAdmin
At the time of writing this post, the latest stable version of PHPMyAdmin is 5.1.1 in the future, this will change. So to keep it working, in the commands replace 5.1.1 with the updated version number.
Now from the / tmp / folder download PHPMyAdmin with the wget command.
cd / tmp / wget https://files.phpmyadmin.net/phpMyAdmin/5.1.1/phpMyAdmin-5.1.1-all-languages.tar.gz
Then unzip it and move it to another location. In this case, I will move it to / usr / share / phpmyadmin.
sudo mv phpMyAdmin-5.1.1-all-languages / usr / share / phpmyadmin
Now create a tmp folder dedicated to PHPMyAdmin. Then make Apache the owner.
sudo mkdir -p / var / lib / phpmyadmin / tmpsudo chown -R www-data: www-data / var / lib / phpmyadmin
Also, create a folder dedicated to settings:
sudo mkdir / etc / phpmyadmin /
Enable the PHPMyAdmin configuration by copying the sample with the configuration name that the program will recognize.
sudo cp /usr/share/phpmyadmin/config.sample.inc.php
/usr/share/phpmyadmin/config.inc.php
This file must be edited to make two modifications.
sudo nano /usr/share/phpmyadmin/config.inc.php
The first is to define a password that helps us increase security.
$ cfg = ”;
The second is to set the path to the temporary folder that we created for PHPMyAdmin. You can add this line.
$ cfg = ‘/ var / lib / phpmyadmin / tmp’;
Save your changes and close the editor. Now you need to add a recommended Apache configuration for ideal access to PHPMyAdmin. So, create the file
sudo nano /etc/apache2/conf-enabled/phpmyadmin.conf
And add the following:
Alias / phpmyadmin / usr / share / phpmyadminServerName your-domain
SymLinksIfOwnerMatchDirectoryIndex index.php options
AddType / x-httpd-php .php application SetHandler application / x-httpd-php php_value include_path .php_admin_value upload_tmp_dir / var / lib / phpmyadmin / tmpphp_admin_value open_basedir / usr / share / phpmyadmin /: / etc / phpmyadmin /: / var / lib / phpmyadmin /: / usr / share-gettext /: / php share / php / share / php / share -php-gettext /: / usr / share / javascript /: / usr / share / php / tcpdf /: / usr / share / doc / phpmyadmin /: / usr / share / php / phpseclib / php_admin_value mbstring.func_overload 0
AddType / x-httpd-php .php application SetHandler application / x-httpd-php < / FilesMatch> php_value include_path .php_admin_value upload_tmp_dir / var / lib / phpmyadmin / tmpphp_admin_value open_basedir / usr / share / phpmyadmin /: / etc / phpmyadmin /: / var / lib / phpmyadmin /: / usr / share-gettext /: / php share / php / share / php / share -php-gettext /: / usr / share / javascript /: / usr / share / php / tcpdf /: / usr / share / doc / phpmyadmin /: / usr / share / php / phpseclib / php_admin_value mbstring.func_overload 0
AuthType BasicAuthName “phpMyAdmin Setup” AuthUserFile /etc/phpmyadmin/htpasswd.setup
Save your changes and close the editor.
Now enable the rewrite module and check the status of the service to see if there is an error.
sudo a2enmod rewrite sudo systemctl restart apache2 sudo systemctl state apache2
Optionally, but recommended, you can secure access to PHPMyAdmin by installing Let’s Encrypt certificates. So, install Certbot and Apache plugin.
sudo apt install certbot python3-certbot-apache
And generate the certificates as follows
sudo certbot –apache -d
Then follow the interactive instructions in the tool. There you will have to define your email address and the installation will be carried out. Then restart Apache.
sudo systemctl restart apache2
Now you can login using your favorite web browser at https: // your-server / phpmyadmin / and you will see the login screen.
Final remarks: How to Run phpMyAdmin Bullseye (Apache) on Debian 11
I hope you understand this article, How to Run phpMyAdmin Bullseye (Apache) on Debian 11. If your answer is no, you can ask anything via the contact forum section related to this article. And if your answer is yes, please share this article with your friends and family to give us your support.
