What is phpMyAdmin?
phpMyAdmin is a free software tool written in PHP, intended to handle the administration of MySQL over the Web. phpMyAdmin supports a wide range of operations on MySQL and MariaDB. Frequently used operations (managing databases, tables, columns, relations, indexes, users, permissions, etc) can be performed via the user interface, while you still have the ability to directly execute any SQL statement.
You need to have an Ubuntu 18.04 server with a non-root sudo-enabled user account and a MySQL server.
If you need help you can contact us.
Install phpMyAdmin from the default Ubuntu repositories:
sudo apt update sudo apt install phpmyadmin php-mbstring php-gettext sudo phpenmod mbstring sudo systemctl restart apache2
Adjusting User Authentication and Privileges:
Configure the root account to authenticate with a password don't forget to change "password" word to your password:
SELECT user,authentication_string,plugin,host FROM mysql.user; ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password'; FLUSH PRIVILEGES; exit