Normally the socket file is created under /tmp/ edit /opt/local/etc/mysql57/my.cnf and do the following:
Change: >> socket = /opt/local/var/run/mysql57/mysqld.sock to >> socket = /tmp/mysqld.sock ________________________________ 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 27, 2020, at 11:23 AM, John Korchok <[email protected]> wrote: > > Hi John, > > As mentioned in my post, I can open mysql -u root -p with no problem. MySQL > is running, it's just the sock file that is not being created. > > John Korchok > > From: John Chung <[email protected]> > Sent: Thursday, March 26, 2020 9:15 PM > To: John Korchok <[email protected]> > Cc: [email protected] > Subject: Re: Misbehaving mysql57-server > > John that looks completely .. > > What happens when you try connect ? > > mysql -u root -p > ________________________________ > 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 26, 2020, at 7:42 PM, John Korchok <[email protected] >> <mailto:[email protected]>> wrote: >> >> Hi all, >> >> This is my second installation of MySQL 5.7. I've had more problems with >> this version than any previous one. The mysql57-server port is installed. >> >> MySQL is running, I can run mysql -u root -p with no problem, but >> mysqld.sock is not created in /opt/local/var/run/mysql57. A mysqld.sock.lock >> file is _is_ created in that folder. >> >> That folder is owned by _mysql, permissions were set to 755, but even 777 >> makes no difference. >> >> /opt/local/etc/mysql57/my.cnf reads: >> >> # Use default MacPorts settings >> !include /opt/local/etc/mysql57/macports-default.cnf >> >> [client] >> user = mysql >> host = localhost >> password = "blahblahblah" >> port = 3306 >> socket = /opt/local/var/run/mysql57/mysqld.sock >> >> [mysqld] >> log-error = /opt/local/var/log/mysql57/mysql-error.log >> socket = /opt/local/var/run/mysql57/mysqld.sock >> >> The error log just shows a normal startup, no issues. What else can I check >> or configure to make this work? >> >> John Korchok >> >> >> <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient&utm_term=icon> >> >> Virus-free. www.avast.com >> <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient&utm_term=link>
