Skip site navigation (1)Skip section navigation (2)
Date:      22 Mar 2021 19:42:49 -0400
From:      "John R. Levine" <>
To:        "Gary Aitken" <>,
Subject:   Re: problems upgrading mysql 5.6 => 5.7
Message-ID:  <>
In-Reply-To: <>
References:  <20210321235845.E3B5870DD030@ary.qy> <>

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.

John Levine,, Primary Perpetrator of "The Internet for Dummies",
Please consider the environment before reading this e-mail.

Want to link to this message? Use this URL: <>