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 <[email protected]> On Behalf Of Bill Cole Sent: Sunday, March 29, 2020 3:04 PM To: [email protected] 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 [email protected] or [email protected] (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
