MariaDB Configuration: Difference between revisions
Jump to navigation
Jump to search
(→Secure) |
(→Secure) |
||
| 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.