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