Home / Blog / Post
How to install PhpMyAdmin on Ubuntu / Debian linux server?
28 December, 2020 by
How to install PhpMyAdmin on Ubuntu / Debian linux server?
Goran Štimac

What is phpMyAdmin?

phpMyAdmin is a free software tool written in PHP, designed to manage MySQL over the Internet. phpMyAdmin supports a wide range of operations on MySQL and MariaDB databases. Frequently used operations (managing databases, tables, columns, relationships, indexes, users, permissions, etc.) can be performed through the user interface, while you still have the ability to directly execute any SQL statement.

Let's set up PhpMyAdmin

Install phpMyAdmin from default Ubuntu repositories:

sudo apt update
sudo apt install phpmyadmin php-mbstring php-gettext
sudo phpenmod mbstring
sudo systemctl restart apache2

Customize user authentication and privileges:

sudo mysql

Configure the root account for authentication with a password and don't forget to change the "password":

SELECT user,authentication_string,plugin,host FROM mysql.user;
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';
FLUSH PRIVILEGES;
exit