Such searches give different instructions on what permissions to give the mysql
datadir !
If the datadir is
/Users/me/Databases/mysql/data
(and my.cnf includes "datadir = /Users/murray/Databases/mysql/data”, of course),
then who should be the owner and what should the permissions be on that
directory?
I see all sorts of answers to that, from various mysql versions, or of varying
vintage, or on various platforms, or on native /usr/… vs. /opt/.. (latter being
MacPorts) configurations — which is leading me to total confusion.
Exactly what chown and chmod commands should be used on the datadir? (Even the
official MySQL docs are incomplete on this.)
> On 25 Oct2018, at 9:37 AM, Ryan Schmidt <[email protected]> wrote:
>
>
>
> On Oct 24, 2018, at 15:25, Murray Eisenberg wrote:
>
>> Starting MySQL
>> . ERROR! The server quit without updating PID file
>> (/Users/me/Databases/mysql/data/mysql.pid).
>>
>
> This is probably not a MacPorts-specific problem; you should search the
> Internet. I did, and one result suggested that this error can occur if the
> server is already running. Another suggested looking at the permissions of
> the directory.
>
> It is curious that it is trying to update a pid file in your data directory
> when your cnf file appear to have told it to put it somewhere else, but I'm
> not sure if that's relevant. It might be, if the data directory and the place
> where the cnf file says to put the pid file have different permissions.
>
>
---
Murray Eisenberg [email protected]
503 King Farm Blvd #101 Home (240)-246-7240
Rockville, MD 20850-6667 Mobile (413)-427-5334
