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

From: Aryeh Friedman <aryeh.friedman_at_gmail.com>
Date: Sun, 28 May 2023 00:14:11 UTC 
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