With the addition of sudo, I get: COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME mysqld 79 _mysql 10u unix 0x40bdd8b3f53719a7 0t0 /opt/local/var/run/mysql56/mysqld.sock
but there is still no sock file at that location. As I mentioned earlier, the mysql-error log does show the creation of the sock file on the last line after restarting. Is there a process that might destroy it after it's created? John Korchok -----Original Message----- From: macports-users <[email protected]> On Behalf Of Bill Cole Sent: Sunday, March 29, 2020 5:52 PM To: [email protected] Subject: Re: Misbehaving mysql57-server 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 [email protected] or [email protected] (AKA @grumpybozo and many *@billmail.scconsult.com addresses) Not For Hire (currently) -- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus
