Skip site navigation (1)Skip section navigation (2)
Date:      22 Mar 2021 19:42:49 -0400
From:      "John R. Levine" <johnl@iecc.com>
To:        "Gary Aitken" <freebsd@dreamchaser.org>, freebsd-questions@freebsd.org
Subject:   Re: problems upgrading mysql 5.6 => 5.7
Message-ID:  <64d150fd-9de-dacf-d88b-2dc57addaf15@iecc.com>
In-Reply-To: <5ec345c3-01a6-f959-0971-5836ecc85e20@dreamchaser.org>
References:  <20210321235845.E3B5870DD030@ary.qy> <5ec345c3-01a6-f959-0971-5836ecc85e20@dreamchaser.org>

Next in thread | Previous in thread | Raw E-Mail | Index | Archive | Help
>> If you're using the mysql-server package, Mysql runs as the mysql
>> user, user ID 88, and all of its data files should belong
>> to mysql.
>> 
>> Unless you really REALLY know what you are doing, nothing but mysql should 
>> be
>> writing the files in its database directory so nobody else should have 
>> write access to it.
>
> Well, I really *don't* know what I'm doing...
> I always started mysqld from a user account.  I didn't pay attention to the
> owner/protections on the files, just set the data dir, and at one point I
> changed the permissions of everything in that account to 600; I may have
> forced the owner/group as well.  I knew mysqld ran as mysql but I thought it
> only did that when started by root.

Assuming you have superuser access to your freebsd box, I think you will 
find that things work better when you run them the way they expect to be 
run.  The mysql-server script expects to he run by root, usually at system 
startup, and then switch to the mysql user.

I do agree that you should get mysql 5.7 working before you try to go to 8.

Regards,
John Levine, johnl@taugh.com, Primary Perpetrator of "The Internet for Dummies",
Please consider the environment before reading this e-mail. https://jl.ly



Want to link to this message? Use this URL: <http://docs.FreeBSD.org/cgi/mid.cgi?64d150fd-9de-dacf-d88b-2dc57addaf15>