mysql-server: The server quit without updating PID file

[Murray Eisenberg]

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 <ryandesign at macports.org> 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			murrayeisenberg at gmail.com
503 King Farm Blvd #101	Home (240)-246-7240
Rockville, MD 20850-6667	Mobile (413)-427-5334


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macports.org/pipermail/macports-users/attachments/20181025/bd3d16b5/attachment.html>