Re: mysql-server: The server quit without updating PID file

2018-10-25 Thread Murray Eisenberg
Once again with mysql, I gave up…uninstalled, then reinstalled following instructions at 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:_mys

Re: mysql-server: The server quit without updating PID file

2018-10-25 Thread Eric A. Borisch
Try running the actual server command to see what is happening; likely there is an error that is preventing startup: sudo -u _mysql /opt/local/lib/mysql57/bin/mysqld - Eric

Re: mysql-server: The server quit without updating PID file

2018-10-25 Thread Ryan Schmidt
On Oct 25, 2018, at 11:01, Murray Eisenberg wrote: > On 25 Oct2018, at 11:58 AM, Ryan Schmidt wrote: >> >> >> On Oct 25, 2018, at 10:34, Murray Eisenberg wrote: >> >>> Such searches give different instructions on what permissions to give the >>> mysql datadir ! >>> >>> If the datadir is >>>

Re: mysql-server: The server quit without updating PID file

2018-10-25 Thread Murray Eisenberg
On 25 Oct2018, at 11:58 AM, Ryan Schmidt wrote: > > > On Oct 25, 2018, at 10:34, Murray Eisenberg wrote: > >> Such searches give different instructions on what permissions to give the >> mysql datadir ! >> >> If the datadir is >> >> /Users/me/Databases/mysql/data >> >> (and my.cnf inc

Re: mysql-server: The server quit without updating PID file

2018-10-25 Thread Ryan Schmidt
On Oct 25, 2018, at 10:34, Murray Eisenberg wrote: > Such searches give different instructions on what permissions to give the > mysql datadir ! > > If the datadir is > > /Users/me/Databases/mysql/data > > (and my.cnf includes "datadir = /Users/murray/Databases/mysql/data”, of > cour

Re: mysql-server: The server quit without updating PID file

2018-10-25 Thread Murray Eisenberg
Such searches give different instructions on what permissions to give the mysql datadir ! If the datadir is /Users/me/Databases/mysql/data (and my.cnf includes "datadir = /Users/murray/Databases/mysql/data”, of course), then who should be the owner and what should the permissions be on

Re: mysql-server: The server quit without updating PID file

2018-10-25 Thread Murray Eisenberg
On 25 Oct2018, at 9:37 AM, Ryan Schmidt wrote: > > > > On Oct 24, 2018, at 15:25, Murray Eisenberg wrote: > >> Starting MySQL >> . ERROR! The server quit without updating PID file >> (/Users/me/Databases/mysql/data/mysql.pid). >> > > … It is curious that it is trying to update a pid

Re: mysql-server: The server quit without updating PID file

2018-10-25 Thread Ryan Schmidt
On Oct 24, 2018, at 15:25, Murray Eisenberg wrote: > Starting MySQL >. ERROR! The server quit without updating PID file > (/Users/me/Databases/mysql/data/mysql.pid). > This is probably not a MacPorts-specific problem; you should search the Internet. I did, and one result suggested

mysql-server: The server quit without updating PID file

2018-10-24 Thread 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 updatin