Installing MariaDB, Apache and phpmyadmin:
apt-get install mariadb-server mariadb-client phpmyadmin apache2 libapache2-mod-php
Set password for mariadb root
# systemctl stop mariadb
# mysqld_safe --skip-grant-tables --skip-networking &
# mysql -u root
MariaDB [(none)]> flush privileges;
Query OK, 0 rows affected (0.006 sec)
MariaDB [(none)]> ALTER USER 'root'@'localhost' IDENTIFIED BY 'your_new_password';
Query OK, 0 rows affected (0.017 sec)MariaDB [(none)]> quit;
Bye# ps aux | grep mariadb
mysql 3155 ....
# kill 3155
# systemctl start mariadb
Access your phpmyadmin using browser http://localhost/phpmyadmin.
Refrence: https://www.digitalocean.com/community/tutorials/how-to-reset-your-mysql-or-mariadb-root-password
