Securing MySQL Installation

This is the step for standard security implementation to a fresh MySQL installation; it will;

• Give the root password
• Remove anonymous users
• Disallow root login remotely
• Remove test database and access to it
• Reload privilege tables

If you answer Y (Yes) to all question. Notice the error log on the output below is because this is not the first time I ran it.

mysql_secure_installation

Enter current password for root (enter for none): Enter
Set root password? [Y/n] Y
New password: rootpasssql
Re-enter new password: rootpasssql
Remove anonymous users? [Y/n] Y
Disallow root login remotely? [Y/n] Y
Remove test database and access to it? [Y/n] Y
Reload privilege tables now? [Y/n] Y