MariaDB Configuration

Internal

• MariaDB
• MySQL Operations

Post-Install

Start at Boot

systemctl enable mariadb.service
systemctl start mariadb.service

Secure

Make sure the database is started.

For MariaDB 10 and newer (the old name of the tool is mysql_secure_installation):

/usr/bin/mariadb-secure-installation

NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB
      SERVERS IN PRODUCTION USE!  PLEASE READ EACH STEP CAREFULLY!
[...]
Enter current password for root (enter for none): <enter>
OK, successfully used password, moving on...
[...]
Switch to unix_socket authentication [Y/n] n
 ... skipping.
[...]
Change the root password? [Y/n] Y
New password:
Re-enter new password:
Password updated successfully!
Reloading privilege tables..
[...]
Remove anonymous users? [Y/n] Y
[...]
Disallow root login remotely? [Y/n] Y
[...]
Remove test database and access to it? [Y/n] Y
[...]
Reload privilege tables now? [Y/n] Y
[...]
All done!  If you've completed all of the above steps, your MariaDB
installation should now be secure.