From nobody Sat May 27 17:20:54 2023 X-Original-To: freebsd-questions@mlmmj.nyi.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2610:1c1:1:606c::19:1]) by mlmmj.nyi.freebsd.org (Postfix) with ESMTP id 4QT7qT0qKPz4V3tw for ; Sat, 27 May 2023 17:21:09 +0000 (UTC) (envelope-from pprocacci@gmail.com) Received: from mail-oo1-xc34.google.com (mail-oo1-xc34.google.com [IPv6:2607:f8b0:4864:20::c34]) (using TLSv1.3 with cipher TLS_AES_128_GCM_SHA256 (128/128 bits) key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest SHA256 client-signature RSA-PSS (2048 bits) client-digest SHA256) (Client CN "smtp.gmail.com", Issuer "GTS CA 1D4" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id 4QT7qR1rhbz3t1N for ; Sat, 27 May 2023 17:21:07 +0000 (UTC) (envelope-from pprocacci@gmail.com) Authentication-Results: mx1.freebsd.org; dkim=pass header.d=gmail.com header.s=20221208 header.b=VSKhdPRI; spf=pass (mx1.freebsd.org: domain of pprocacci@gmail.com designates 2607:f8b0:4864:20::c34 as permitted sender) smtp.mailfrom=pprocacci@gmail.com; dmarc=pass (policy=none) header.from=gmail.com Received: by mail-oo1-xc34.google.com with SMTP id 006d021491bc7-5576c2791e6so1108424eaf.1 for ; Sat, 27 May 2023 10:21:07 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20221208; t=1685208066; x=1687800066; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=2fkbcRkHtXYimHLOtIscxEi1VAyIWEQEt6/BRUqhohQ=; b=VSKhdPRISlAQz8ACfylYYcrfNm7Z4zXHOMafFEiX3CBcyfl4511TLgP4wzaDdBcLIk fGWtGPvY9z1OOeSfV0gb02PCYvNYOrw+oJpj78r87ZondoiXIhdettOAP+LDTlf7JhPy 29yH+Z20HBWpm1lI4SjzV1ujE2pyHsuuuuVeqe1qkyB0SOmEXhiH3Cr1KCFj63IizjFx hKeMuKULGhoTDs9E6LIB5vzscNYrEi+fSQmIo/Nhlms8OimAKuaMCPY72EcXb8KJmSHz 3I7262eohfJOJmOXC+1euwD4vyr56d5QzJcwRgAklQkB3M58yaehp3XYByZAacjrMVvs 0lNw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1685208066; x=1687800066; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=2fkbcRkHtXYimHLOtIscxEi1VAyIWEQEt6/BRUqhohQ=; b=HNw/nc4biMNeUpeNuvoY21bJg8Y5XNrn59+DDB7uQA95ESMachazgfYnyd9TunFXKF mZeWdFAN0o+lXM9e9GpEwxjjBmvfF11RMshAYdeNxvG+RzoJqMeYNVZLwpS/xT/G12hl p+v0WxQgIgyB19gWUVGMO0vpyOTTAWt+RpgHiL6+64QvY5FRy4/emyix9/IMPaqbsJKS 46D7G4dLI+MqTKSpDJpolWTB72ZqhnhmU/7n+A5/U5hGwwfmglmPDl8BDI1lCuKAoRYy J7AIuq7PtV0H9b6+0L6tvX+OtqE85f4FGcIHyXKbJ/f2UMUctUVXYlwWX1s3YzKP7WeR fEMg== X-Gm-Message-State: AC+VfDx0nMe7O64CiNwfyiPZlVYIU0xoGC55jkPAjlEDNpzJX/Wf7mcr Md+dxdwa9/lNHL5XGEmFFDKkPFMeKeNz+BoJiQ== X-Google-Smtp-Source: ACHHUZ4frTu1wv5bRhAfqy8fw/1pywANggUb8msNQfwRO1nzXc/7Gb7DmCA0HAtCQ93D7LKTkR2zVq4DPNU4KiRIZVo= X-Received: by 2002:a54:4102:0:b0:398:47ad:6621 with SMTP id l2-20020a544102000000b0039847ad6621mr2971050oic.8.1685208065683; Sat, 27 May 2023 10:21:05 -0700 (PDT) List-Id: User questions List-Archive: https://lists.freebsd.org/archives/freebsd-questions List-Help: List-Post: List-Subscribe: List-Unsubscribe: Sender: owner-freebsd-questions@freebsd.org X-BeenThere: freebsd-questions@freebsd.org MIME-Version: 1.0 References: In-Reply-To: From: Paul Procacci Date: Sat, 27 May 2023 13:20:54 -0400 Message-ID: Subject: Re: What happened to my /tmp/mysql.sock ?!!??! To: Aryeh Friedman Cc: Odhiambo Washington , FreeBSD Mailing List Content-Type: multipart/alternative; boundary="00000000000020b5d105fcb014ba" X-Spamd-Result: default: False [-3.75 / 15.00]; NEURAL_HAM_LONG(-1.00)[-1.000]; NEURAL_HAM_MEDIUM(-0.91)[-0.910]; NEURAL_HAM_SHORT(-0.84)[-0.840]; DMARC_POLICY_ALLOW(-0.50)[gmail.com,none]; R_DKIM_ALLOW(-0.20)[gmail.com:s=20221208]; R_SPF_ALLOW(-0.20)[+ip6:2607:f8b0:4000::/36]; MIME_GOOD(-0.10)[multipart/alternative,text/plain]; RCPT_COUNT_THREE(0.00)[3]; FROM_HAS_DN(0.00)[]; TAGGED_RCPT(0.00)[]; FREEMAIL_FROM(0.00)[gmail.com]; TO_MATCH_ENVRCPT_SOME(0.00)[]; PREVIOUSLY_DELIVERED(0.00)[freebsd-questions@freebsd.org]; MLMMJ_DEST(0.00)[freebsd-questions@freebsd.org]; RCVD_IN_DNSWL_NONE(0.00)[2607:f8b0:4864:20::c34:from]; ARC_NA(0.00)[]; SUBJECT_HAS_QUESTION(0.00)[]; FREEMAIL_CC(0.00)[gmail.com,freebsd.org]; DKIM_TRACE(0.00)[gmail.com:+]; SUBJECT_ENDS_EXCLAIM(0.00)[]; TO_DN_ALL(0.00)[]; MID_RHS_MATCH_FROMTLD(0.00)[]; DWL_DNSWL_NONE(0.00)[gmail.com:dkim]; FREEMAIL_TO(0.00)[gmail.com]; RCVD_TLS_LAST(0.00)[]; ASN(0.00)[asn:15169, ipnet:2607:f8b0::/32, country:US]; FROM_EQ_ENVFROM(0.00)[]; FREEMAIL_ENVFROM(0.00)[gmail.com]; MIME_TRACE(0.00)[0:+,1:+,2:~]; RCVD_COUNT_TWO(0.00)[2] X-Rspamd-Queue-Id: 4QT7qR1rhbz3t1N X-Spamd-Bar: --- X-ThisMailContainsUnwantedMimeParts: N --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 wrote: > On Sat, May 27, 2023 at 1:09=E2=80=AFPM Odhiambo Washington > 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 > > > > > > 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


On Sat, May 27, 2023 at 1:13=E2= =80=AFPM Aryeh Friedman <ary= eh.friedman@gmail.com> wrote:
On Sat, May 27, 2023 at 1:09=E2=80=AFPM Odhiambo Washi= ngton <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 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 !?!?!?=C2=A0 Literally installed 5 mins<= br> 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 po= tentially mysql_install_db.

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.

mysqld --initialize

= 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.

~Paul

--
__________________

:(){ :|:& };:
<= /div>
--00000000000020b5d105fcb014ba--