phpMyAdmin is a web tool for managing MySQL and MariaDB databases from the browser.
It is a free and very popular tool for creating databases, running queries, reviewing tables, or doing small administration tasks without opening a desktop client.
Installing PHPMyAdmin on Raspberry Pi is very simple. First, you should have a web server like Apache with PHP and a database like MariaDB installed.
To install PHPMyAdmin from a command console, we do:
sudo apt update sudo apt install phpmyadmin php-mbstring php-gettext
We will be asked a series of questions to configure PHPMyAdmin. First, we select apache2 as the server by pressing SPACE and then ENTER.
Next, we will be asked for the password for the database ‘root’, and a password to access PHPMyAdmin.
Now we create a new user in the database, which we will use with PHPMyAdmin. To do this, we access MariaDB as root.
sudo mariadb -u root -p
And we use the following command to create a user ‘username’ with password ‘password’ (replace with your desired data).
GRANT ALL PRIVILEGES ON . TO ‘username’@‘localhost’ IDENTIFIED BY ‘password’;
We exit the MariaDB console by doing:
quit
Finally, we restart Apache by doing:
sudo service apache2 restart
Now we can check that everything is working correctly by opening a web browser and going to the address:
IP/phpmyadmin
That is how simple it is. phpMyAdmin is very popular and is included in many server setups. It is convenient for quick tasks from the browser, although for day-to-day work with databases it is also worth knowing desktop clients such as DBeaver.
