MariaDB Configuration: Difference between revisions
Jump to navigation
Jump to search
(Created page with "=Internal= * MariaDB =Start at Boot= <pre> systemctl enable mariadb systemctl start mariadb </pre>") |
(→Secure) |
||
| (19 intermediate revisions by the same user not shown) | |||
| Line 2: | Line 2: | ||
* [[MariaDB]] | * [[MariaDB]] | ||
* [[MySQL Operations]] | |||
=Start at Boot= | =Post-Install= | ||
==Start at Boot== | |||
<pre> | <pre> | ||
systemctl enable mariadb | systemctl enable mariadb.service | ||
systemctl start mariadb | systemctl start mariadb.service | ||
</pre> | </pre> | ||
==Secure== | |||
Make sure the database is started. | |||
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> | |||
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. | |||
</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.