Misbehaving mysql57-server

[Bill Cole]

On 29 Mar 2020, at 17:09, Dave Horsfall wrote:

> On Sun, 29 Mar 2020, Bill Cole wrote:
>
>> So there's a socket somewhere. To see where, try this:
>>
>> lsof -U -a -p $( pgrep mysqld )
>
>     Daves-MacBook-Pro:~ dave$ lsof -U -a -p $( pgrep mysqld )
>     lsof: no process ID specified
>     lsof 4.89
>      latest revision: ftp://lsof.itap.purdue.edu/pub/tools/unix/lsof/
>      latest FAQ: ftp://lsof.itap.purdue.edu/pub/tools/unix/lsof/FAQ
>      latest man page: 
> ftp://lsof.itap.purdue.edu/pub/tools/unix/lsof/lsof_man
>      usage: [-?abhlnNoOPRtUvV] [+|-c c] [+|-d s] [+D D] [+|-f[cgG]]
>      [-F [f]] [-g [s]] [-i [i]] [+|-L [l]] [+|-M] [-o [o]] [-p s]
>      [+|-r [t]] [-s [p:s]] [-S [t]] [-T [t]] [-u s] [+|-w] [-x [fl]] 
> [--] [names]
>     Use the ``-h'' option to get more help information.

Do you have a mysqld process running?  Are you using a version of MacOS 
with pgrep?

One thing I missed in that: you need to run that as root, so add a sudo 
in front. But if you have pgrep and mysqld running you should not get an 
error from lsof, just nothing becausre non-root users can't look at 
other users' processes.

> What shell/lsof are you using?

~ root# lsof -v
lsof version information:
     revision: 4.89
     latest revision: ftp://lsof.itap.purdue.edu/pub/tools/unix/lsof/
     latest FAQ: ftp://lsof.itap.purdue.edu/pub/tools/unix/lsof/FAQ
     latest man page: 
ftp://lsof.itap.purdue.edu/pub/tools/unix/lsof/lsof_man
     configuration info: libproc-based
     Anyone can list all files.
     /dev warnings are disabled.
     Kernel ID check is disabled.
~ root# echo $BASH_VERSION
3.2.57(1)-release



-- 
Bill Cole
bill at scconsult.com or billcole at apache.org
(AKA @grumpybozo and many *@billmail.scconsult.com addresses)
Not For Hire (currently)