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
--00000000000020b5d105fcb014ba Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Sat, May 27, 2023 at 1:13=E2=80=AFPM Aryeh Friedman <aryeh.friedman@gmai= l.com> wrote: > On Sat, May 27, 2023 at 1:09=E2=80=AFPM Odhiambo Washington <odhiambo@gma= il.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 star= t. > > 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 --=20 __________________ :(){ :|:& };: --00000000000020b5d105fcb014ba Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable <div dir=3D"ltr"><div><div dir=3D"ltr"><br></div><br><div class=3D"gmail_qu= ote"><div dir=3D"ltr" class=3D"gmail_attr">On Sat, May 27, 2023 at 1:13=E2= =80=AFPM Aryeh Friedman <<a href=3D"mailto:aryeh.friedman@gmail.com">ary= eh.friedman@gmail.com</a>> wrote:<br></div><blockquote class=3D"gmail_qu= ote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,20= 4);padding-left:1ex">On Sat, May 27, 2023 at 1:09=E2=80=AFPM Odhiambo Washi= ngton <<a href=3D"mailto:odhiambo@gmail.com" target=3D"_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 initializ= e 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 sta= rt.<br> <br> This *IS* a completely new install !?!?!?=C2=A0 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=3D"http://www.PetiteCloud.org" r= el=3D"noreferrer" target=3D"_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 po= tentially mysql_install_db.<br><br></div><div>It's possible this comman= d doesn't exist due to it being part of mysqld in later versions of mys= ql.=C2=A0 If that's the case then the following should initialize the d= atabases.</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. Was= hington was suggesting and repost an new error messages.</div><div><br></di= v><div><div><div>~Paul</div> <br><span class=3D"gmail_signature_prefix">-- </span><br><div dir=3D"ltr" c= lass=3D"gmail_signature">__________________<br><br>:(){ :|:& };:</div><= /div></div></div> --00000000000020b5d105fcb014ba--
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?CAFbbPugb3YkqXWsPGR%2B_2F1eHA_vwcKKz6=Fy5fgDhUjo0P%2B-A>