Install MariaDB (MIROR) Debian 9

apt-get install -y software-properties-common dirmngr

apt-key adv --recv-keys --keyserver keyserver.ubuntu.com 0xF1656F24C74CD1D8

add-apt-repository 'deb [arch=amd64,i386,ppc64el] http://nyc2.mirrors.digitalocean.com/mariadb/repo/10.4/debian stretch main'

apt-get update

apt-get install -y --allow-unauthenticated mariadb-server mariadb-client

mysql_secure_installation


    Enter current password for root (enter for none):  << No Password - Press Enter

    Switch to unix_socket authentication [Y/n] N  << Disabling Unix Socket login and enabling password Login

    Change the root password? [Y/n] Y  << Change MariaDB root password

    New password:   << Enter Password

    Re-enter new password:   << Re-Enter Password

    Remove anonymous users? [Y/n] Y  << Remove Anonymous users

    Disallow root login remotely? [Y/n] Y  << Disallow root login remotely

    Remove test database and access to it? [Y/n] Y  << Remove test database

    Reload privilege tables now? [Y/n] Y  << Reload privilege



systemctl stop mariadb

systemctl start mariadb

systemctl status mariadb

mysql -u root -p
#Password required