Date: Sat, 27 May 2023 20:14:11 -0400 From: Aryeh Friedman <aryeh.friedman@gmail.com> To: Paul Procacci <pprocacci@gmail.com> Cc: Odhiambo Washington <odhiambo@gmail.com>, FreeBSD Mailing List <freebsd-questions@freebsd.org> Subject: Re: What happened to my /tmp/mysql.sock ?!!??! Message-ID: <CAGBxaXn9spaKrBxJ5Pq7LjFeotjAy0ZVZ3=N3jyQZAMcVKbPkw@mail.gmail.com> In-Reply-To: <CAFbbPugb3YkqXWsPGR%2B_2F1eHA_vwcKKz6=Fy5fgDhUjo0P%2B-A@mail.gmail.com> References: <CAGBxaXkGMdp7sev9=UnE1sMQA9ni6-sBKfdE78-T28VPM2Hd%2BA@mail.gmail.com> <CAAdA2WNY9MH1fFrfF=25%2BquxeUvLR1B71QpUo9v-fyi4egv25g@mail.gmail.com> <CAGBxaXmKoYJS-giea7v5F39hZ5G06XnhMuQA0YNARQHJ4md=gw@mail.gmail.com> <CAAdA2WO7VNPLwqX06a-eoSpqxROezysy-vDT7zKcW1QYkM1xPw@mail.gmail.com> <CAGBxaXnDVHZ0%2BUS3j0deDXOEVQFznMV7GNHi6jaD%2B6RVws4uYg@mail.gmail.com> <CAAdA2WNLUEG8CYSkNXLZ8Re=F2sJyqGooD3mqBf8fDo%2By-sGug@mail.gmail.com> <CAGBxaX=UV=dXKO=qn7=KS=dip3rUG3=LT=qVRu2eKg%2BTsckaRA@mail.gmail.com> <CAFbbPugb3YkqXWsPGR%2B_2F1eHA_vwcKKz6=Fy5fgDhUjo0P%2B-A@mail.gmail.com>
next in thread | previous in thread | raw e-mail | index | archive | help
On Sat, May 27, 2023 at 1:21=E2=80=AFPM Paul Procacci <pprocacci@gmail.com>= wrote: > > > > On Sat, May 27, 2023 at 1:13=E2=80=AFPM Aryeh Friedman <aryeh.friedman@gm= ail.com> wrote: >> >> On Sat, May 27, 2023 at 1:09=E2=80=AFPM Odhiambo Washington <odhiambo@gm= ail.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 initializ= e 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 sta= rt. >> >> 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 i= n later versions of mysql. If that's the case then the following should in= itialize 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=3D270807 > > Once one of the two are completed, then you can try the things that Mr. W= ashington was suggesting and repost an new error messages. > > ~Paul > > -- > __________________ > > :(){ :|:& };: --=20 Aryeh M. Friedman, Lead Developer, http://www.PetiteCloud.org
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?CAGBxaXn9spaKrBxJ5Pq7LjFeotjAy0ZVZ3=N3jyQZAMcVKbPkw>