Misbehaving mysql57-server

[John Korchok]

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 <jchung at nyquest.com> 
Sent: Friday, March 27, 2020 11:38 AM
To: John Korchok <jkorchok at gmail.com>
Cc: macports-users at 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 <jkorchok at gmail.com <mailto:jkorchok at 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 <jchung at nyquest.com <mailto:jchung at nyquest.com> >  
Sent:  Thursday, March 26, 2020 9:15 PM
To:  John Korchok <jkorchok at gmail.com <mailto:jkorchok at gmail.com> >
Cc:  macports-users at lists.macports.org <mailto: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/e0db8197/attachment.html>