We will show you, how to install phpMyAdmin on Debian 9, running with Apache, PHP 7 and MySQL. phpMyAdmin is one of the most popular and widely used web-based database management tools. It is a free and open source PHP application that allows the users to manage single or multiple SQL database servers locally or on a remote server using a web browser (GUI). With phpMyAdmin you can easily create, rename, delete and edit databases, tables or fields, execute SQL commands, import, and export tables, create and modify users, etc., all of that just through your browser. Installing phpMyAdmin on Debian 9 is an easy task, just carefully follow the steps below, and you should have phpMyAdmin installed on your Debian based server in less than 10 minutes. Let’s get started.
Table of Contents
1. Login via SSH
First, log in to your server via SSH as user root:
ssh root@yourIPaddress
2. Update System Packages
and make sure that you have the latest version of all installed packages by running:
apt-get update && apt-get upgrade
3. Install LAMP Stack
To install phpMyAdmin on your Debian server, a LAMP (Linux, Apache, MariaDB/MySQL, PHP) stack is required.
If you don’t have a LAMP stack already installed on your server, you can do it by executing the following commands
apt-get install apache2 php mysql-server
4. Install phpMyAdmin on Debian 9
Once Apache, PHP, and MySQL are installed, you can proceed with the phpMyAdmin installation. You can simply run the following command:
apt-get install phpmyadmin
phpMyAdmin will be installed along with all its dependencies and necessary PHP modules.
5. Configure Web Server
During the installation, you will be asked to select which web server to configure, hit the spacebar to select Apache2 and press Enter to confirm and continue:
lqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqu Configuring phpmyadmin tqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqq x Please choose the web server that should be automatically configured to run phpMyAdmin. x x x x Web server to reconfigure automatically: x x x x [ ] apache2 x x [ ] lighttpd x x x x x x <OK> x mqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj
On the following screen, select YES to configure a database for phpMyAdmin with dbconfig-common:
qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqq Configuring phpmyadmin qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqq x x x The phpmyadmin package must have a database installed and configured before it can be used. x x This can be optionally handled with dbconfig-common. x x x x If you are an advanced database administrator and know that you want to perform this configuration x x manually, or if your database has already been installed and configured, you should refuse this option x x Details on what needs to be done should most likely be provided in /usr/share/doc/phpmyadmin. x x x x Otherwise, you should probably choose this option. x x x x Configure database for phpmyadmin with dbconfig-common? x x x x <Yes> <No> x x x mqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqq
6. Set up strong password
and finally set a password for the ‘phpmyadmin’ user in MySQL:
qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqq Configuring phpmyadmin qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqq x x x Please provide a password for phpmyadmin to register with the database server. If left blank, a random password will be generated. x x x x MySQL application password for phpmyadmin: x x x x x x <Yes> <No> x x x qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqq Configuring phpmyadmin qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqq
With this step, the installation of phpMyAdmin is completed. You can now access it at http://yourIPaddress/phpmyadmin and log in using your MySQL username and password.
If you have a Debian optimized hosting with us, there is no need to install phpMyAdmin on Debian 9 yourself. Instead, you can ask our Linux Administrators to install phpMyAdmin on Debian 9. They are available 24/7 and can help you out with any issues or requests that you have.
PS. If you like our blog posts, we’d appreciate you sharing this post on, how to install phpMyAdmin on Debian 9, on social networks by using the shortcuts below, or you can post a comment under the share shortcuts. Thanks.
Bonjour j’ai l’erreur :
mysqli_real_connect(): (HY000/1698): Access denied for user ‘root’@’localhost’
Comment y remédier, merci de votre aide.
same here
ok good its work !
Works perfect, thank you.