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)
