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: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?64d150fd-9de-dacf-d88b-2dc57addaf15>