Database Reference
In-Depth Information
On Linux systems, we generally do the following (and we may need to preface it
with sudo):
/etc/init.d/mysql reload
Example my.cnf file
There's an awful lot of information in this chapter about file locations,
comments, options, groups, and so on. If you're anything like me, your
head is probably swimming, wondering how you're ever going to make
sense of it all. To see a big picture view of how everything works together
I've created an example
my.cnf
file with lots of comments to explain the
different parts and settings of a typical
my.cnf
file. You can download it
from the topic's website.
Summary
That's it for our configuration highlights tour! The next chapter is on securing
MariaDB. After all, now that we know how to configure MariaDB to our liking, we
wouldn't want some nefarious character to mess things up, now would we? We'll
cover an easy way to secure our new installation of MariaDB, and go over basic
things we can do to keep our database secure.
