MySQL 8: datadir
noloader at gmail.com
Sun Oct 4 15:25:43 UTC 2020
On Sun, Oct 4, 2020 at 10:57 AM Murray Eisenberg
<murrayeisenberg at gmail.com> wrote:
> Problem SOLVED!
> Trouble was in my.cnf I had specified
> pid-file = /opt/local/var/run/mysq8/mysqld.pid
> but apparently mysqld could not write to that directory — even though I had previously executed
> sudo chown -R _mysql:_mysql /opt/local/var/run/mysql8/
> and when I checked there the correct ownership was in effect.
> By commenting out the “pid-file=…” line in my.cnf, the mysql8-server starts normally and I can connect to it with the mysql (= mysql8) client.
> Still somewhat mysterious!
MySQL startup is fragile. There are several Ubuntu bugs for MySQL
startup behaviors. If your ownership is root:mysql with permission
0770 it will refuse to start because it only checks owner, and not
More information about the macports-users