PHPMyAdmin by default will block you from logging into the PHPMyAdmin interface using the “ root” user. With the PHPMyAdmin installation process complete, there is one last thing we need to do. This password is what PHPMyAdmin will use to connect to the MySQL server.ĥ. It is best to set this password to something different to your root SQL password. It will now ask you to set a password for PHPMyAdmin itself. To do this select “ ” at the next prompt.Ĥ. We will also need set up some details so that we can log in to the PHPMyAdmin software. Next, we will need to configure PHPMyAdmin to connect to our MYSQL server. Select this option even if you are using NGINX as we will configure that ourselves latest on.ģ. Select the “ apache2” option by pressing SPACE and then ENTER.

You will be presented with a screen asking the type of web server you want it to run off. It will require your input on various steps along the way. PHPMyAdmin will now begin to install to your Pi. To install the PHPMyAdmin package to our Raspberry Pi, we need to run the command below. If you don’t have this, you will not be able to install PHPMyAdmin.ġ. You will need to have the password you set up for the root MYSQL account. You will also need to install and setup MYSQL. Setting up PHPMyAdmin on the Raspberry PiĪs with all of our tutorials, we will be using the latest version of Raspbian to complete this tutorial.įirst, make sure that you followed the previous tutorial on installing a web server with PHP support.

You will need the pieces of equipment listed below to complete this Raspberry Pi PHPMyAdmin tutorial. If you haven’t already installed a web server, you can learn from our guide on installing Apache or our guide to installing NGINX. I recommend checking out some tutorials if you’re completely new to managing databases. Learning how to use PHPMyAdmin is quite daunting for beginners.

You to need have a web server on your Raspberry Pi set up and ready to use. You will find that installing Raspberry Pi PHPMyAdmin is very easy to do and won’t take long. It is hugely popular and used in a lot of web server environments throughout the world. In this Raspberry Pi PHPMyAdmin tutorial, we will take you through the steps on how to install the popular MySQL administration tool PHPMyAdmin to your Raspberry Pi.įor anyone who doesn’t know, PHPMyAdmin is a free tool that has been designed to allow for easy administration of MySQL.

Install phpmyadmin debian 10