Skip site navigation (1)Skip section navigation (2)
Date:      Sun, 2 Feb 2020 01:17:27 +0300
From:      Andreas X <hamdi20193d@gmail.com>
To:        Polytropon <freebsd@edvax.de>
Cc:        Paul Pathiakis <pathiaki2@yahoo.com>,  "freebsd-questions@freebsd.org" <freebsd-questions@freebsd.org>
Subject:   Re: No my.cnf file at all?
Message-ID:  <CAEW8WPsU7h486bMog6wefqdz4KmZkjV5iUHA_wgig8tdZGKQcQ@mail.gmail.com>
In-Reply-To: <20200201211024.ac11b2d8.freebsd@edvax.de>
References:  <CAEW8WPtad9RVyRs1P6BfjYmKCXctQiaXAA0_o39F_tY4ANWS2A@mail.gmail.com> <1065217562.310518.1580586031261@mail.yahoo.com> <CAEW8WPtm1RGNtTjJ5sXCK%2Bk8QAe=xgSumh0DSh-kcUBLpBxcDg@mail.gmail.com> <20200201211024.ac11b2d8.freebsd@edvax.de>

next in thread | previous in thread | raw e-mail | index | archive | help
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 =C5=9Eubat 2020 Cumartesi tarihinde Polytropon <freebsd@edvax.de> yazd=C4=
=B1:

> 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 see=
ms
> > 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, ...
>



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?CAEW8WPsU7h486bMog6wefqdz4KmZkjV5iUHA_wgig8tdZGKQcQ>