No my.cnf file at all?

[Andreas X]

Hi again,

I installed via packages, not ports. And as I stated earlier, I searched
for ANY file, any directory with extension .cnf, it is unbelieveable but it
seems they removed it.

Mariadb 10.4, FreeBSD 12.1.

I need to optimize, configure and customize my MariaDB installation, that's
why I need that file.

Creating a local my own my.cnf file from randomly-grabbed sample config
files over the Internet would be horrible. A lot of different variables
such as datadir, socket path, etc, would be a huge mess.

Any idea?



1 Şubat 2020 Cumartesi tarihinde Polytropon <freebsd at edvax.de> yazdı:

> 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/
>
>
>
> --
> Polytropon
> Magdeburg, Germany
> Happy FreeBSD user since 4.0
> Andra moi ennepe, Mousa, ...
>