The simplest way to add a bit of extra security to our MariaDB installation is just a command line away.
To secure a default install of MariaDB, perform the following steps:
Open a terminal and run the following command:
mysql_secure_installationAs prompted by the script, set a password for the
rootuser, disallow remoterootlogins, and remove anonymous users.Since we've been using the
testdatabase for various recipes in the current and other chapters, we may not want to remove it when prompted.Reload the privilege tables when prompted.
The mysql_secure_installation program is actually just a script written in PERL. Its sole purpose is to apply some basic security settings that nearly every MariaDB installation should have. This script should be run first thing after installing MariaDB on a server. It takes only a minute and should be considered as an essential step that we must perform whenever we install MariaDB...
