Hi John,
Are you referring to a Macports installation? I'm following the steps in https://trac.macports.org/wiki/howto/MySQL Switching the location creates the same result. /private/tmp/mysqld.sock.lock is created, but not the sock file. John Korchok From: John Chung <jch...@nyquest.com> Sent: Friday, March 27, 2020 11:38 AM To: John Korchok <jkorc...@gmail.com> Cc: macports-users@lists.macports.org Subject: Re: Misbehaving mysql57-server 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 <jkorc...@gmail.com <mailto:jkorc...@gmail.com> > 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 <jch...@nyquest.com <mailto:jch...@nyquest.com> > Sent: Thursday, March 26, 2020 9:15 PM To: John Korchok <jkorc...@gmail.com <mailto:jkorc...@gmail.com> > Cc: macports-users@lists.macports.org <mailto:macports-users@lists.macports.org> 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 <jkorc...@gmail.com <mailto:jkorc...@gmail.com> > 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. <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient&utm_term=link> www.avast.com -- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus
