mysql-server: The server quit without updating PID file

[Murray Eisenberg]

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

---
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/20181025/9a93037a/attachment.html>