Check configuration file of MariaDB

Find the location of the Configuration file of MariaDB

On Linux, Ubuntu, or Debian: Check the following location for the configuration file of MariaDB:

/etc/mysql/my.cnf  -- At Global level

/etc/mysql/mariadb.cnf -- this file say to scan the folder for /etc/mysql/conf.d and /etc/mysql/mariadb.conf.d . File include following line to scan:
!includedir /etc/mysql/conf.d/ 
!includedir /etc/mysql/mariadb.conf.d/ 

/etc/mysql/mariadb.conf.d/50-server.cnf -- In MyCase i modified this file by matching other variable set in this with SELECT @@variable command by connecting

On CentOS:

/etc/my.cnf

/etc/mysql/my.cnf

For Windows, Go to the services.msc and Right-click on MariaDB services, and select the properties:

Check the configuration file used with help of the command:

mysqld --help --verbose

Default options are read from the following files in the given order:
C:\WINDOWS\my.ini C:\WINDOWS\my.cnf C:\my.ini C:\my.cnf C:\Program Files\MariaDB 10.6\my.ini C:\Program Files\MariaDB 10.6\my.cnf C:\Program Files\MariaDB 10.6\data\my.ini C:\Program Files\MariaDB 10.6\data\my.cnf

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.