NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FORALL MariaDB SERVERS IN PRODUCTION USE! PLEASE READEACH STEP CAREFULLY!
Inordertologinto MariaDB to secure it, we'll need the current password for the root user. If you've just installed MariaDB, and haven't set the root password yet, you should just press enter here.
Enter current password for root (enter for none):
首次使用默认无密码, 按回车跳过
1 2 3 4 5 6 7 8
OK, successfully used password, moving on...
Setting the root password orusingthe unix_socket ensures that nobody can logintothe MariaDB root user withoutthe proper authorisation.
You already have your root account protected, so you can safely answer 'n'.
Switch to unix_socket authentication [Y/n]
上述表示root账户已保护, 可以按N跳过
1 2 3 4
Enabled successfully! Reloading privilege tables.. ... Success! Change the root password? [Y/n] y
按Y进入MariaDB root账户密码修改,修改要求输入密码两次, 此处不做赘述
1 2 3 4 5 6 7
Bydefault, a MariaDB installation has an anonymous user, allowing anyone tologinto MariaDB withouthavingto have a user account created for them. This is intended onlyfor testing, andto make the installation go a bit smoother. You should remove them before moving into a production environment.
Remove anonymous users? [Y/n] y
是否删除匿名用户 是(Y)
1 2 3 4 5 6
... Success!
Normally, root should only be allowed to connect from'localhost'. This ensures that someone cannot guess atthe root password fromthe network.
Disallow root login remotely? [Y/n] y
禁止远程登录, 建议是(Y)
1 2 3 4 5 6 7
... Success!
By default, MariaDB comes witha database named 'test' that anyone can access. This is also intended only for testing, and should be removed before moving intoa production environment.
Remove test database and access toit? [Y/n] y
删除默认的测试库, 建议是(Y)
1 2 3 4 5 6 7 8 9 10
Dropping test database... ... Success!
Removing privileges on test database... ... Success!
Reloading the privilege tables will ensure that all changes made so far will take effect immediately.
Reload privilege tables now? [Y/n] y
重新加载权限表使设置生效, 是(Y)
1 2 3 4 5 6 7 8
... Success!
Cleaning up...
All done! If you've completed allof the above steps, your MariaDB installation should now be secure.