[Bug 194305] databases/mariadb55-server (probably mysql too) ignores datadir directive in my.cnf

[bugzilla-noreply at freebsd.org]

https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=194305

--- Comment #13 from Markus Kohlmeyer <rootservice at gmail.com> ---
(In reply to Mahdi Mokhtari from comment #10)
Yes, MySQL 5.7 is affected too.

Affected are *all* MySQL, MariaDB and Percona ports.


(In reply to Kubilay Kocak from comment #11)
If i underatnd this all right, then it was/is like this:

The rc.conf/initscript options had been introduced, because FreeBSD uses a
different standard for the location of the databases
(MySQL/MariaDB/Percona-Standard: /var/lib/mysql vs. FreeBSD-Standard:
/var/db/mysql). As MySQL/MariaDB/Percona need to know the database location on
first startup and FreeBSD did not installed a default my.cnf in the past, there
had to be a commandline param to pass and this commandline param had been made
configureable via the rc.conf option.

In the progress on updating the MySQL 5.7 port from 5.7.10 to 5.7.12 i
introduced a default my.cnf and changed the default location of the my.cnf from
the old FreeBSD-Location (/var/db/mysql/my.cnf) to the
MySQL/MariaDB/Percona-Standard and according to hier(8) to
/usr/local/etc/mysql/my.cnf
This change and the new default my.cnf should first be ported to the other
MySQL/MariaDB/Percona ports and then we can think about getting rid of the
rc.conf/initscript options. But without this change and the default my.cnf we
have to stick with the 11 year old solution.

Just my $0.02

-- 
You are receiving this mail because:
You are the assignee for the bug.