Misbehaving mysql57-server

[John Korchok]

Hi Bill,

Thanks, but that command doesn't return any information.

I haven't enabled networking. In the Activity Monitor, MySQL is running.

I tried installing mysql56, then switched to that version, but that isn't creating a sock file either. In the mysql-error log, mySQL thinks it's created the sock file (I saw nearly identical messages in 5.7 error log):
Version: '5.6.45' socket:  '/opt/local/var/run/mysql56/mysqld.sock'  port: 0 Source distribution

But that folder only contains the hidden file .turd_mysql56-server (same thing in 5.7).

However, in 5.6, when I try to sign in to mysql I get this:

mysql -u root -p
Enter password:

###########################
client_connect
###########################

Establishing a connection to '' ...
[MySQL-5.6.45  ][1049] Unknown database 'test'

Check the connection options using --help or -?



Any more ideas anyone?

John

-----Original Message-----
From: macports-users <macports-users-bounces at lists.macports.org> On Behalf Of Bill Cole
Sent: Sunday, March 29, 2020 3:04 PM
To: macports-users at lists.macports.org
Subject: Re: Misbehaving mysql57-server

On 27 Mar 2020, at 11:23, John Korchok wrote:

> 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.

If the socket isn't there, it raises the question of how the mysql client is working with no problem, since that socket is how the client normally connects to the server. Unless you've modified the config to enable networking (which you should not unless it is essential to access the server from another machine.)

So there's a socket somewhere. To see where, try this:

lsof -U -a -p $( pgrep mysqld )



--
Bill Cole
bill at scconsult.com or billcole at apache.org (AKA @grumpybozo and many *@billmail.scconsult.com addresses) Not For Hire (currently)


-- 
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus