Misbehaving mysql57-server

[Bill Cole]

NOTE: There's no need to mail me copies of replies that are also sent to 
the list. I am actually LESS likely to see messages sent to my 
list-specific addresses which do not arrive via their list.

On 29 Mar 2020, at 17:00, John Korchok wrote:

> Hi Bill,
>
> Thanks, but that command doesn't return any information.

I should have included 'sudo' before that command because you do need to 
run it as root. Like this:

	$ sudo lsof -U -a -p $( pgrep mysqld )
	Password:
	COMMAND   PID   USER   FD   TYPE             DEVICE SIZE/OFF NODE NAME
	mysqld  74438 _mysql   21u  unix 0x1a24756463c9ab69      0t0      
/opt/local/var/run/mysql57/mysqld.sock

> I haven't enabled networking. In the Activity Monitor, MySQL is 
> running.
>
> I tried installing mysql56, then switched to that version, but that 
> isn't creating a sock file either. In the mysql-error log, mySQL 
> thinks it's created the sock file (I saw nearly identical messages in 
> 5.7 error log):
> Version: '5.6.45' socket:  '/opt/local/var/run/mysql56/mysqld.sock'  
> port: 0 Source distribution
>
> But that folder only contains the hidden file .turd_mysql56-server 
> (same thing in 5.7).

I am mystified. I installed mysql57 with MacPorts for the first time to 
look into this problem and didn't run into the missing socket problem 
nor did I get that hidden file:

	$ ls -la /opt/local/var/run/mysql57/
	total 8
	drwxr-xr-x  4 _mysql  _mysql  128 Mar 29 00:41 .
	drwxr-xr-x  5 root    wheel   160 Mar 27 15:38 ..
	srwxrwxrwx  1 _mysql  _mysql    0 Mar 28 22:48 mysqld.sock
	-rw-------  1 _mysql  _mysql    6 Mar 28 22:48 mysqld.sock.lock


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