Debian 9 - Install MariaDB
If you need a "MySQL" server for something like Wordpress, then you can just install MariaDB from the default repositories quickly and easily.
sudo apt update sudo apt install mariadb-server -y
Login In As Root
MariaDB will now use the
unix socket for authentication of the root account. It is best not to change this, and just log in with:
Creating Sub Accounts
To give a website like wordpress access to the MySQL database, we will create a user account for them.
create database wordpress; GRANT ALL ON `wordpress`.* to wordpress@localhost identified by 'passwordHere';
First published: 14th March 2019