Database Reference
In-Depth Information
Disallow root login remotely? [Y/n] y
... Success!
By default, MariaDB comes with a database named 'test' that anyone can
access. This is also intended only for testing, and should be removed
before moving into a production environment.
Remove test database and access to it? [Y/n] y
- Dropping test database...
... Success!
- Removing privileges on test database...
... Success!
Reloading the privilege tables will ensure that all changes made so far
will take effect immediately.
Reload privilege tables now? [Y/n] y
... Success!
Cleaning up...
All done! If you've completed all of the above steps, your MariaDB
installation should now be secure.
As the output of the script says, after running it, our MariaDB installation is now
secure. In fact, if we run it immediately after installing MariaDB the only user that
will now be able to connect is
root
, and it will only be able to do so while we are
logged in to or sitting in front of the actual computer MariaDB is running on. This
isn't very convenient and we don't want to give other users or applications the root
user password, so we'll eventually have to add users and open things up at least a
little.
Chapter 4
,
MariaDB User Account Management
, goes into this subject.
Connecting safely
Now that the root user has a password, it's up to us to make sure the password—and
the passwords of all other users we will inevitably create—stay secure. One of the
most important ways to do that is to always follow a good connection practice.
