Misbehaving mysql57-server

[John Korchok]

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 <jchung at nyquest.com> 
Sent: Thursday, March 26, 2020 9:15 PM
To: John Korchok <jkorchok at gmail.com>
Cc: macports-users at 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 <jkorchok at gmail.com <mailto:jkorchok at 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macports.org/pipermail/macports-users/attachments/20200327/40cef126/attachment.html>