John a couple more questions 1. How are you starting mysql ? I am not using the macports version of mysql 5.7, as I compiled my version from source, but I start it with the following:
sh-3.2# /usr/local/mysql/bin/mysqld_safe --user=_mysql & [1] 581 sh-3.2# 2020-03-30T03:04:30.6NZ mysqld_safe Logging to ‘/var/log/mysql.err'. 2020-03-30T03:04:30.6NZ mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data 2. In my my.cnf, I have the following: [mysqld_safe] log-error=/var/mysql/mysql.log pid-file=/var/mysql/mysql.pid do you have a mysqld_safe block? ________________________________ John T. Chung Technical Architect +1.419.464.9637 | Office +1.419.973.9072 | Mobile Nyquest Consulting http://www.nyquest.com <http://www.nyquest.com/> > On Mar 29, 2020, at 11:05 PM, Bill Cole > <[email protected]> wrote: > > On 29 Mar 2020, at 19:58, John Korchok wrote: > >> 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? > > That could be p[art of some convoluted explanation, but I think the > explanation is MUCH simpler. > > Are you relying on the Finder to look in /opt/local/var/run/mysql56/? Don't. > It will not show you everything. Use 'ls' instead. > > > -- > Bill Cole > [email protected] or [email protected] > (AKA @grumpybozo and many *@billmail.scconsult.com addresses) > Not For Hire (currently)
