Database Reference
In-Depth Information
On YUM distributions such as Fedora, Red Hat, and CentOS, the location of the
plugin directory varies depending on whether our system is 32 bit or 64 bit. If
unsure, just look in both. The possible locations are as follows:
/lib64/mysql/plugin/
/lib/mysql/plugin/
A basic rule of thumb is that if we don't have a
/lib64/
directory, we have the 32-bit
version of Fedora, Red Hat, or CentOS installed.
The last directory we want to know is only found on APT-based distributions
(Debian and Ubuntu) by default. It is as follows:
/etc/mysql/
The
/etc/mysql/
directory is where configuration information for MariaDB is
stored. Specifically in the following two locations:
/etc/mysql/my.cnf
/etc/mysql/conf.d/
There are some other files in the directory, but we can ignore them for now.
We'll look into more detail of the
my.cnf
file in the
The MariaDB configuration
ile
section. And we'll talk about the
conf.d
directory in the
Modular configuration
on Linux
section.
Fedora, Red Hat, and CentOS systems don't have a
/etc/mysql/
directory by
default, but they do have the
my.cnf
file and a
my.cnf.d
directory. They are at the
following two location:
/etc/my.cnf
/etc/my.cnf.d/
The
my.cnf
files function the same on all Linux versions and on Windows, where it
is often named
my.ini
. The
my.cnf.d
and
conf.d
directories, despite their different
names, serve the same purpose. We'll spend the rest of our highlights tour talking
about the
my.cnf
file after going over the
my.cnf.d
and
conf.d
directories. Feel free
to skip the next section if you are working with Windows.
Modular configuration on Linux
The
my.cnf.d
and
conf.d
directories are special locations for MariaDB configuration
files. They are found on MariaDB releases for Linux such as Debian, Ubuntu, Fedora,
Red Hat, and CentOS. By default, they are at the following two locations:
/etc/my.cnf.d/
/etc/mysql/conf.d/