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			murrayeisenberg at gmail.com
503 King Farm Blvd #101	Home (240)-246-7240
Rockville, MD 20850-6667	Mobile (413)-427-5334


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macports.org/pipermail/macports-users/attachments/20181024/8f299bb7/attachment.html>