Clear all

How to find which MariaDB configuration file is being used Ubuntu  

Joined: 7 years ago
Posts: 270
Topic starter  

When you replace MySQL with MariaDB or install MariaDB on a fresh Ubuntu server, it's important to find the correct config file to make your changes. Because if you edit the wrong file, your changes will not take effect. A user reported similar situation few months ago where Virtualmin loading incorrect mariadb config file and the changes they make had no effect at all. 

I pointed them to right direction. But still location of the loaded MariaDB can change from server to server as there are few locations that MariaDB look for the configuration. Best way to find it is to ask,

which mysqld

This returned following output,


Now modify and execute following command based on the output you got.

/usr/sbin/mysqld --verbose --help | grep -A 1 "Default options"

MariaDB will tell you what location it look for config file and in what order.

Topic Tags
Back to top button

We use cookies to give you the best online experience. By agreeing you accept the use of cookies in accordance with our cookie policy.