On Sun, Oct 4, 2020 at 10:57 AM Murray Eisenberg <murrayeisenb...@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 group. Jeff