目的 mysql_secure_installation

mysql -u root

# Set the root user password for all local domains

SET PASSWORD FOR 'root'@'localhost' = PASSWORD('my_password');

SET PASSWORD FOR 'root'@'localhost.localdomain' = PASSWORD('my_password');

SET PASSWORD FOR 'root'@'127.0.0.1' = PASSWORD('my_password');

# Drop the Any user

DROP USER ''@'localhost';

DROP USER ''@'localhost.localdomain';

# Exit MySQL

exit

        mysql_secure_installation

      

        mysql_secure_installation