MariaDB Security Installation Steps

Secure your MariaDB installation with these essential steps

Initial Command: sudo mysql_secure_installation

🔒 Security Recommendations

1
Start Security Installation
Command: sudo mysql_secure_installation
Initialize the MariaDB security script
2
Root Password Check
Prompt: Enter current password for root (enter for none):
Response: [Press Enter - no password]
Pressed Enter since no root password was previously set
3
Unix Socket Authentication
Prompt: Switch to unix_socket authentication [Y/n]
Response: Y
Enable unix_socket authentication for better security
4
Change Root Password
Prompt: Change the root password? [Y/n]
Response: N
Chose not to change the root password since unix_socket authentication will be used instead
5
Remove Anonymous Users
Prompt: Remove anonymous users? [Y/n]
Response: Y
Remove anonymous user accounts for security
6
Disable Remote Root Login
Prompt: Disallow root login remotely? [Y/n]
Response: Y
Prevent root login from remote connections
7
Remove Test Database
Prompt: Remove test database and access to it? [Y/n]
Response: Y
Delete the default test database
8
Reload Privilege Tables
Prompt: Reload privilege tables now? [Y/n]
Response: Y
Apply all security changes immediately

🎉 Installation Complete!

Your MariaDB installation is now secure and ready for production use.

Thanks for using MariaDB!

Generated on 2025-09-11 15:51:18 | MariaDB Security Configuration Reference