From the course: Linux System Engineer: Database Servers Using MariaDB
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
MariaDB configuration files
From the course: Linux System Engineer: Database Servers Using MariaDB
MariaDB configuration files
- The main MariaDB Configuration files stored at /etc/my.cnf and is the same location as it is with MySQL. The my.cnf file sets global defaults for the mysql command as well as a mysqld_safe script and the MySQL service. Let's take a look at it using VI. In a terminal type in, "sudo vi /etc/my.cnf" and hit enter. In this file, comments are preceded by a hash mark. This file can contain three configuration groups for the mysql command and a mysqld_safe script. By default it only includes two of these. Mysqld and mysqld_safe. We can see under the mysqld group that we have an item for the data directory. This is where the databases are stored and in our case it's set to /var/lib/mysql. If you decide to move the location of the database file, you will need to edit this line as well as change the selinux security policy database, and the security context of the new directory. This file also lists the location for the database socket files for both mysqld and mysqld_safe. Under the…
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.