Notifications
Clear all

How to find which MariaDB configuration file is being used Ubuntu  

  RSS

Tharindu
(@tharindu)
Admin
Joined: 6 years ago
Posts: 211
31/01/2020 10:12 am  

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,

/usr/sbin/mysqld

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.

This topic was modified 5 months ago by Tharindu

Become a vpsfix.com affiliate and earn up to 10% commissions from your referrals


Quote
Topic Tags
Share:
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.

Close