Sample Analysis of MySQL Security configuration Wizard mysql_secure_installation

This article will explain in detail the sample analysis of mysql_secure_installation, the MySQL security configuration wizard. The editor thinks it is very practical, so I share it with you for reference. I hope you can get something after reading this article.

After installing mysql-server, you will be prompted to run mysql_secure_installation. Running mysql_secure_ installation executes several settings:

A) set the password for root users

B) Delete anonymous accounts

C) cancel remote login for root users

D) remove the test library and access to the test library

E) refresh the authorization table to make the changes effective

Through these settings, the security of mysql library can be improved. It is recommended that you run mysql_secure_installation once after mysql installation in the production environment. For detailed steps, please see the following command:

The copy code is as follows:

[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):