mysqld 5.7: server quit without updating PID file

Murray Eisenberg murrayeisenberg at gmail.com
Tue Sep 22 20:16:03 UTC 2020


Something changed when updating various mysql-related ports recently: I can no longer start mysqld. Error is:

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

Below is my /opt/local/etc/mysql57/my.cnf file.  It includes the macports-default.cnf file, whose only non-commented lines are:

	[mysqld]
	skip-networking

What could be wrong?

I’ve searched on-line, and nothing I’ve found so far seems to be relevant (most referring to installations directly from mysql download into /usr/local or else to installations using homebrew.

To the best of my knowledge, I have not intervened to change any permissions on the data files, 
which are in /Users/me/Databases/mysql/data

	# my.cnf
	#
	# Use default MacPorts settings
	!include /opt/local/etc/mysql57/macports-default.cnf

	# For advice on how to change settings please see
	# http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html

	[mysqld]

	# Remove leading # and set to the amount of RAM for the most important data
	# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
	# innodb_buffer_pool_size = 128M

	# Remove leading # to turn on a very important data integrity option: logging
	# changes to the binary log between backups.
	# log_bin = mysql-bin

	# These are commonly set, remove the # and set as required.
	# basedir = /usr/local/mysql 
	# basedir = /opt/local/lib/mysql57
	# datadir = /usr/local/mysql/data
	# datadir = /Users/me/mysql/data 
	# datadir = /opt/local/var/db/mysql56
	datadir = /Users/me/Databases/mysql/data
	port = 3306
	# server_id = .....
	# socket = /tmp/mysql.sock
	socket = /opt/local/var/run/mysql57/mysqld.sock
	# pid-file = /opt/local/var/run/mysqld/mysqld.pid

	# Remove leading # to set options mainly useful for reporting servers.
	# The server defaults are faster for transactions and fast SELECTs.
	# Adjust sizes as needed, experiment to find the optimal values.
	# join_buffer_size = 128M
	# sort_buffer_size = 2M
	# read_rnd_buffer_size = 2M 

	sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES 

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

	# end my.cnf

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




More information about the macports-users mailing list