Install MariaDB
If you want to use the latest MariaDB release on a fresh server, you need at first to add the MariaDB 10.2 repository :
curl -sS https://downloads.mariadb.com/MariaDB/mariadb_repo_setup \
| sudo bash -s -- --mariadb-server-version=10.3 --skip-maxscale
Then you can install mariadb-server :
sudo apt update && sudo apt install mariadb-server
Secure MariaDB
It’s not needed to set a root password during the installation, but instead you can use the commmand mysql_secure_installation
to set root password, to deny remote root login and to remove anonymous users and useless tables.
You can use the following command to generate a strong password before using mysql_secure_installation
:
cat /dev/urandom | tr -dc 'a-zA-Z0-9' | fold -w 32 | head -n 1
Then create a file /etc/mysql/conf.d/my.cnf to provide root credentials to EasyEngine with the following content :
[client]
user = root
password = new-password