SECURING MYSQL / MARIADB WITH MYSQL_SECURE_INSTALLATION

SECURING MYSQL / MARIADB WITH MYSQL_SECURE_INSTALLATION

We'll be performing basic security in a mariadb installation like, root password, test databases removal, etc. Lets go ahead and check this put.

1. Run the Command mysql_secure_installation

It'll ask for setting the root password. Press Y to do so.

2. It'll disallow remote root login.
3. Remove anonymous user.
4. it'll drop test databases.