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

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

-- 
__________________

:(){ :|:& };: