No my.cnf file at all?

[Manish Jain]

On 2020-02-02 01:40, Polytropon wrote:
> On Sat, 1 Feb 2020 23:02:44 +0300, Andreas X wrote:
>> Hi Paul,
>>
>> I did such search not only in /usr/local, but entire server. No, it seems
>> they removed adding any .cnf file on the latest mariadb-server release.
>>
>> Could someone verify that please?
> 
> The search for my.cnf or my.cnf.sample does not lead to any results
> because MariaDB has a different naming convention (i. e., not the
> ".sample" suffix everyone else uses).
> 
> Try this:
> 
> 	# find /usr/local -name my-default.cnf
> 
> As you have installed it as a port (and it doesn't belong to the
> FreeBSD OS), the location beneath /usr/local is correct. I don't
> know if the sample file is already in /usr/local/etc or maybe
> /usr/local/etc/mysql, maybe you'll find it in /usr/local/share
> somewhere.
> 
> Your actual configuration file /usr/local/etc/my.cnf can then be
> created with the my-default.cnf template file.
> 
> More information here:
> 
> https://mariadb.com/kb/en/configuring-mariadb-with-option-files/
> 
> 
> 

I usually find it equally handy to use:

/usr/libexec/locate.updatedb  (as root)
locate my.cnf

Regards,
Manish Jain