MariaDB Configuration: Difference between revisions

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

Revision as of 01:51, 1 January 2024

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.