MySQL 8: datadir

[Jeffrey Walton]

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
group.

Jeff