Re: What happened to my /tmp/mysql.sock ?!!??!

On Sat, May 27, 2023 at 8:14 PM Aryeh Friedman <aryeh.friedman@gmail.com>
wrote:

> On Sat, May 27, 2023 at 1:21 PM Paul Procacci <pprocacci@gmail.com> wrote:
> >
> >
> >
> > On Sat, May 27, 2023 at 1:13 PM Aryeh Friedman <aryeh.friedman@gmail.com>
> wrote:
> >>
> >> On Sat, May 27, 2023 at 1:09 PM Odhiambo Washington <odhiambo@gmail.com>
> wrote:
> >> > 2023-05-27T12:40:12.835631Z 0 [ERROR] Fatal error: Can't open and
> lock privilege tables: Table 'mysql.user' doesn't exist
> >> > 2023-05-27T12:40:12.835637Z 0 [ERROR] Fatal error: Failed to
> initialize ACL/grant/time zones structures or failed to remove temporary
> table files.
> >> > 2023-05-27T12:40:12.835752Z 0 [ERROR] Aborting
> >> > </quote>
> >> >
> >> > Please completely uninstall Mysql and reinstall afresh and it will
> start.
> >>
> >> This *IS* a completely new install !?!?!?  Literally installed 5 mins
> >> before I posted on a complete fresh VM
> >> >
> >> > Even better, install MariaDB :-)
> >>
> >> Since I need to debug a mysql DB on a production server not an option
> >> --
> >> Aryeh M. Friedman, Lead Developer, http://www.PetiteCloud.org
> >>
> >
> > I didn't catch the version of mysql you were attempting to run but one
> of two commands will solve your problem.
> > The first is potentially mysql_install_db.
> >
> > It's possible this command doesn't exist due to it being part of mysqld
> in later versions of mysql.  If that's the case then the following should
> initialize the databases.
> >
> > mysqld --initialize
> Already tried both this seems to be related to a series of bugs all up
> and down the mysql food chain in the last few weeks:
> https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=270807
>
>
> >
> > Once one of the two are completed, then you can try the things that Mr.
> Washington was suggesting and repost an new error messages.
> >
> > ~Paul
> >
> > --
> > __________________
> >
> > :(){ :|:& };:
>
>
>
> --
> Aryeh M. Friedman, Lead Developer, http://www.PetiteCloud.org
>

Some things excluded from the OPS original post (or I had to search for
referenced in the provided logs)
The mysql version is 5.7.41.
He's using latest.  Not quarterly.

Series of commands that I've done to create an mysql 5.7.41 environment:
zfs send tank/jails/templates/13.1-RELEASE-stripped@initial | zfs recv
tank/jails/hosts/mysql-test
zfs set mountpoint=/jails/hosts/mysql-test tank/jails/hosts/mysql-test
pkg -r /jails/hosts/mysql-test install -y mysql57-server-5.7.41
/etc/rc.d/jail onestart mysql-test

*To follow along the jail id that got created has a numeric identifier of
17.
From there:

jexec -u root 17 /usr/local/etc/rc.d/mysql-server onestart
# pgrep -j 17 -l mysqld
58398 mysqld

I cannot replicate the OPs problem.

Note the installation from the port:

"===>   NOTICE:

This port is deprecated; you may wish to reconsider installing it:"

~Paul
-- 
__________________

:(){ :|:& };: