[BlueOnyx:24369] Re: In mysql, user at localhost and user at 127.0.0.1 are different.

[Tomohiro Hosaka]

2020年10月7日(水) 10:49 Tomohiro Hosaka <bokutin at gmail.com>:
> > Yeah, this was done deliberately and intentionally.
> >
> > Starting with CentOS 7 the included MariaDB started to treat localhost,
> >  127.0.0.1 and ::1 differently - regardless what /etc/hosts said.
> >
> > Like anyone else we would prefer to use <user>@<localhost>, but that no
> > longer worked in certain scenarios and also wrecked portability of MySQL
> > users when moved between BlueOnyx versions.
> >
> > For that reason we've now hard-coded MySQL local credentials to
> > <username>@<127.0.0.1> instead to avoid these problems.
>
> What is "certain scenarios"?
>
> What is "these problems"?
>
> It seems that BlueOnyx tried to replace localhost with 127.0.0.1 for that,
> but I would like to know the reason for that replacement.

I haven't tried the 5210R yet, but maybe one of the reasons is that
the chroot jail by jailkit etc. can't access /var/lib/mysql/mysql.sock
etc.

I would be grateful if you could answer.