mysql-server: The server quit without updating PID file

[Murray Eisenberg]

Environment:  macOS 10.14, MacPorts 2.5.4

Port:  mysql57-server @5.7.17_0 (active)

At my wits end as to why suddenly mysqld won’t start.

Command:

        sudo /opt/local/share/mysql57/support-files/mysql.server start

Response:

        Starting MySQL
   . ERROR! The server quit without updating PID file 
(/Users/me/Databases/mysql/data/mysql.pid).

The active (non-commented) lines of /opt/local/etc/mysql57/my.cnf are:

        !include /opt/local/etc/mysql57/macports-default.cnf

        [mysqld]
        datadir = /Users/me/Databases/mysql/data
        port = 3306
        socket = /opt/local/var/run/mysql57/mysqld.sock
        pid-file = /opt/local/var/run/mysqld/mysqld.pid
        sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES 

        [client]
        socket = /opt/local/var/run/mysql57/mysqld.sock

Permissions:

        ls -ld  /opt/local/var/run/mysqld
drwxr-xr-x  2 _mysql  _mysql  64 Oct 24 16:08 /opt/local/var/run/mysqld
    ls -ld /opt/local/var/run/mysql57
drwxr-xr-x  4 _mysql  _mysql  128 Oct 24 13:10 /opt/local/var/run/mysql57

I had used: sudo chown -R mysql:mysql /opt/local/var/run/mysqld

What’s wrong?

Note: So far as I’m aware, I had not changed anything recently except for 
normal “sudo port sync” and "sudo port upgrade outdated”.

---
Murray Eisenberg                        murrayeisenb...@gmail.com
503 King Farm Blvd #101 Home (240)-246-7240
Rockville, MD 20850-6667        Mobile (413)-427-5334