Bug 211464

Summary: pkg 1.8.2 upgrade chown mysql -> 88
Product: Ports & Packages Reporter: Aleks <Z462vasa>
Component: Individual Port(s)Assignee: freebsd-pkg (Nobody) <pkg>
Status: New ---    
Severity: Affects Only Me CC: stievenard.david, w.schwarzenfeld
Priority: ---    
Version: Latest   
Hardware: Any   
OS: Any   

Description Aleks 2016-07-30 17:43:18 UTC
pkg 1.8.2 upgrade chown mysql -> 88 

chown -R mysql:mysql /var/db/mysql
Comment 1 John Marino freebsd_committer 2016-08-03 13:51:32 UTC
This PR is cryptic (an example of not explaining the problem nor why the proposed the best fix).  In any case, assign to pkg.
Comment 2 dasti 2016-09-13 09:01:50 UTC
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
Comment 3 Walter Schwarzenfeld freebsd_triage 2018-02-03 09:04:23 UTC
Is this still relevant?
Comment 4 dasti 2018-02-07 11:12:11 UTC
didn't had the time to test on freebsd 11.1
my guess is that it's a port problem (?)