problems upgrading mysql 5.6 => 5.7

[John R. Levine]

>> 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 at taugh.com, Primary Perpetrator of "The Internet for Dummies",
Please consider the environment before reading this e-mail. https://jl.ly