Adminer

Instalation of apache2, php, mariadb-server (MySQL) and related modules

apt install apache2 php libapache2-mod-php php-curl php-cli php-mysql php-gd mariadb-server mysql-client

Enable and start apache2 + mariadb

systemctl start apache2
systemctl start mariadb
systemctl enable apache2
systemctl enable mariadb

mysql_secure_installation

wget "http://www.adminer.org/latest.php" -O /var/www/html/adminer.php
chown -R www-data:www-data /var/www/html/adminer.php
chmod 755 /var/www/html/adminer.php

http://your-ip/adminer.php

TIP

while in mysql, disable root login by running

use mysql; update user set plugin='' where User='root'; flush privileges; exit;

change root password that will be required

mysql -u root -p SET PASSWORD FOR 'root'@'localhost' = PASSWORD("newpassword"); flush privileges; exit;