Once again with mysql, I gave up…uninstalled, then reinstalled following instructions at
https://trac.macports.org/wiki/howto/MySQL <https://trac.macports.org/wiki/howto/MySQL> but editing my.cnf so as to specify my own datadir, creating that datadir, and applying sudo chown -R _mysql:_mysql [mydatadir] to it. Finally, recreating databases from backups. Still haven’t a clue as to why starting mysqld was failing. > On 24 Oct2018, at 4:25 PM, Murray Eisenberg <murrayeisenb...@gmail.com> wrote: > > 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 > <mailto:murrayeisenb...@gmail.com> > 503 King Farm Blvd #101 Home (240)-246-7240 > Rockville, MD 20850-6667 Mobile (413)-427-5334 > > --- Murray Eisenberg murrayeisenb...@gmail.com 503 King Farm Blvd #101 Home (240)-246-7240 Rockville, MD 20850-6667 Mobile (413)-427-5334
