MySQL平安設置裝備擺設領導mysql_secure_installation詳解。本站提示廣大學習愛好者：（MySQL平安設置裝備擺設領導mysql_secure_installation詳解）文章只能為提供參考，不一定能成為您想要的結果。以下是MySQL平安設置裝備擺設領導mysql_secure_installation詳解正文
裝置完mysql-server 會提醒可以運轉mysql_secure_installation。運轉mysql_secure_installation會履行幾個設置：
a)為root用戶設置暗碼
b)刪除匿名賬號
c)撤消root用戶長途登錄
d)刪除test庫和對test庫的拜訪權限
e)刷新受權表使修正失效
經由過程這幾項的設置可以或許進步mysql庫的平安。建議臨盆情況中mysql裝置這完成後必定要運轉一次mysql_secure_installation，具體步調請參看上面的敕令:
[root@server1 ~]# mysql_secure_installation
NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MySQL
SERVERS IN PRODUCTION USE! PLEASE READ EACH STEP CAREFULLY!
In order to log into MySQL to secure it, we'll need the current
password for the root user. If you've just installed MySQL, and
you haven't set the root password yet, the password will be blank,
so you should just press enter here.
Enter current password for root (enter for none):<–首次運轉直接回車
OK, successfully used password, moving on…
Setting the root password ensures that nobody can log into the MySQL
root user without the proper authorisation.
Set root password? [Y/n] <– 能否設置root用戶暗碼，輸出y並回車或直接回車
New password: <– 設置root用戶的暗碼
Re-enter new password: <– 再輸出一次你設置的暗碼
Password updated successfully!
Reloading privilege tables..
… Success!
By default, a MySQL installation has an anonymous user, allowing anyone
to log into MySQL without having to have a user account created for
them. This is intended only for testing, and to make the installation
go a bit smoother. You should remove them before moving into a
production environment.
Remove anonymous users? [Y/n] <– 能否刪除匿名用戶,臨盆情況建議刪除，所以直接回車
… Success!
Normally, root should only be allowed to connect from 'localhost'. This
ensures that someone cannot guess at the root password from the network.
Disallow root login remotely? [Y/n] <–能否制止root長途登錄,依據本身的需求選擇Y/n並回車,建議制止
… Success!
By default, MySQL comes with a database named 'test' that anyone can
access. This is also intended only for testing, and should be removed
before moving into a production environment.
Remove test database and access to it? [Y/n] <– 能否刪除test數據庫,直接回車
- 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] <– 能否從新加載權限表，直接回車
… Success!
Cleaning up…
All done! If you've completed all of the above steps, your MySQL
installation should now be secure.
Thanks for using MySQL!
[root@server1 ~]#
