Misbehaving mysql57-server

[John Chung]

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 <macportsusers-20171215 at billmail.scconsult.com> 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
> bill at scconsult.com or billcole at apache.org
> (AKA @grumpybozo and many *@billmail.scconsult.com addresses)
> Not For Hire (currently)

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macports.org/pipermail/macports-users/attachments/20200329/590a16d4/attachment.html>