Date: Sat, 27 May 2023 13:20:54 -0400 From: Paul Procacci <pprocacci@gmail.com> To: Aryeh Friedman <aryeh.friedman@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: <CAFbbPugb3YkqXWsPGR%2B_2F1eHA_vwcKKz6=Fy5fgDhUjo0P%2B-A@mail.gmail.com> In-Reply-To: <CAGBxaX=UV=dXKO=qn7=KS=dip3rUG3=LT=qVRu2eKg%2BTsckaRA@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>
next in thread | previous in thread | raw e-mail | index | archive | help
[-- Attachment #1 --] 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 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 -- __________________ :(){ :|:& };: [-- Attachment #2 --] <div dir="ltr"><div><div dir="ltr"><br></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Sat, May 27, 2023 at 1:13 PM Aryeh Friedman <<a href="mailto:aryeh.friedman@gmail.com">aryeh.friedman@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">On Sat, May 27, 2023 at 1:09 PM Odhiambo Washington <<a href="mailto:odhiambo@gmail.com" target="_blank">odhiambo@gmail.com</a>> wrote:<br> > 2023-05-27T12:40:12.835631Z 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist<br> > 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.<br> > 2023-05-27T12:40:12.835752Z 0 [ERROR] Aborting<br> > </quote><br> ><br> > Please completely uninstall Mysql and reinstall afresh and it will start.<br> <br> This *IS* a completely new install !?!?!? Literally installed 5 mins<br> before I posted on a complete fresh VM<br> ><br> > Even better, install MariaDB :-)<br> <br> Since I need to debug a mysql DB on a production server not an option<br> -- <br> Aryeh M. Friedman, Lead Developer, <a href="http://www.PetiteCloud.org" rel="noreferrer" target="_blank">http://www.PetiteCloud.org</a><br>; <br> </blockquote></div> <div><br>I didn't catch the version of mysql you were attempting to run but one of two commands will solve your problem.</div><div>The first is potentially mysql_install_db.<br><br></div><div>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.</div><div><br></div><div>mysqld --initialize</div><br></div><div>Once one of the two are completed, then you can try the things that Mr. Washington was suggesting and repost an new error messages.</div><div><br></div><div><div><div>~Paul</div> <br><span class="gmail_signature_prefix">-- </span><br><div dir="ltr" class="gmail_signature">__________________<br><br>:(){ :|:& };:</div></div></div></div>
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?CAFbbPugb3YkqXWsPGR%2B_2F1eHA_vwcKKz6=Fy5fgDhUjo0P%2B-A>