pkg 1.8.2 upgrade chown mysql -> 88 FIXED : chown -R mysql:mysql /var/db/mysql
This PR is cryptic (an example of not explaining the problem nor why the proposed the best fix). In any case, assign to pkg.
I think I can help on this one :) on freeBSD 10.3 installed package mysql56-server - 'pkg install mysql56-server' changed pkg configuration file to the 'lastest' - from this line -- 'url: "pkg+http://pkg.FreeBSD.org/${ABI}/quarterly",' - to this line -- 'url: "pkg+http://pkg.FreeBSD.org/${ABI}/latest",' refreshed and it updated mysql server from 5.6.30 to 5.6.32 - 'pkg update' tried to start mysql doesn't work, no error in /var/log/message error appears in mysql's error log file (sorry I don't have the path anymore) the fix that worked for me is to give back permissions for the user mysql to the this directory -> /var/db/mysql a link to someone getting the same problem (certainly on another OS) -> http://dba.stackexchange.com/a/99365
Is this still relevant?
didn't had the time to test on freebsd 11.1 my guess is that it's a port problem (?)
This is not familiar to me, I just check and can't reproduce, let's assume it has been fixed in the mean time.