MariaDB Configuration

From NovaOrdis Knowledge Base
Revision as of 01:51, 1 January 2024 by Ovidiu (talk | contribs) (→‎Secure)
Jump to navigation Jump to search

Internal

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.