MariaDB Configuration: Difference between revisions
Jump to navigation
Jump to search
(→Secure) |
|||
| (5 intermediate revisions by the same user not shown) | |||
| Line 5: | Line 5: | ||
=Post-Install= | =Post-Install= | ||
==Start at Boot== | |||
<pre> | |||
systemctl enable mariadb.service | |||
systemctl start mariadb.service | |||
</pre> | |||
==Secure== | ==Secure== | ||
< | Make sure the database is started. | ||
/usr/bin/ | |||
</ | For MariaDB 10 and newer (the old name of the tool is <code>mysql_secure_installation</code>): | ||
<syntaxhighlight lang='bash'> | |||
/usr/bin/mariadb-secure-installation | |||
</syntaxhighlight> | |||
< | <font size=-2> | ||
Enter current password for root (enter for none): | NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB | ||
... | SERVERS IN PRODUCTION USE! PLEASE READ EACH STEP CAREFULLY! | ||
... | [...] | ||
Remove anonymous users? [Y/n] Y | |||
... | Enter current password for root (enter for none): <enter> | ||
Disallow root login remotely? [Y/n] Y | OK, successfully used password, moving on... | ||
... | |||
Remove test database and access to it? [Y/n] Y | [...] | ||
... | |||
Reload privilege tables now? [Y/n] Y | 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. | |||
</font> | |||
Latest 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.