From nobody Sun May 28 00:14:11 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 4QTK0H5n7cz4X1Xl for ; Sun, 28 May 2023 00:14:23 +0000 (UTC) (envelope-from aryeh.friedman@gmail.com) Received: from mail-ed1-x52b.google.com (mail-ed1-x52b.google.com [IPv6:2a00:1450:4864:20::52b]) (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 4QTK0H53Psz47XQ for ; Sun, 28 May 2023 00:14:23 +0000 (UTC) (envelope-from aryeh.friedman@gmail.com) Authentication-Results: mx1.freebsd.org; none Received: by mail-ed1-x52b.google.com with SMTP id 4fb4d7f45d1cf-5149aafef44so74840a12.0 for ; Sat, 27 May 2023 17:14:23 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20221208; t=1685232862; x=1687824862; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=sRF0yHIK3TfthjYOUZuLHM5Et9u5z037qbZ7MTCDASY=; b=aEHl+xsnuOt8RJed+Xh1IDynLcyyc3YdyA6KsQGzBX40jiroWOFZ/bhx/iisfCUtiQ 0Nn+ezkzl9nyMgtkiJ66LrubHceWxg0u01GMtpg/tUSqpXUrQ9v0zaDOXCAJr8GA75TT MpVUXWuNlceHVr+H6yDLhMjqoISvNRwIkrOCfvhrdH3nEy/3l67Xv3rCsrakl9i8kleD n+Y6XOQg+BFpDV2tElwitEDMoamjAV72FGqkHCUS77tzNRBnGivzk1x38Eg5tqpgXy8f BgRLox0owxmempbRotd3RjsAEToDT4aq/hhh2r4ccRaQOCbXpGDSCgcrbS5aFRs1PWDo SS6A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1685232862; x=1687824862; h=content-transfer-encoding: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=sRF0yHIK3TfthjYOUZuLHM5Et9u5z037qbZ7MTCDASY=; b=T8c+CyvS66jtsGB+g1l1CCKkZ5Ckpq2mm/gLZd9ZZKJwOpeSCUxWnMFxJDCQ883bXL LZAxKpyBmlxCIYTpkriUkppOvR3tiMhwIdO7zvT0E/Kc05xjMfRS4UshDXiCUoftlJs3 fsuhWXZPxmlyb0YFRGWh0AsbisplRx2ZJrA8pwug5pyC1NHt0jJO2lyE6+U9u177D4O7 OwIKJWzPKQMv87aWllcdWJqL2gh6l4j9HMSIOJ9mujDQpFEG/Gi1ReBxPu2I0v87x238 N/wY1DROyXeiXyxe5yQgdzyUrL0QseFeKuzazNiX2z8huwVEwUcPXcpYHmSJArphaJXu 2Vdw== X-Gm-Message-State: AC+VfDyqsqWD+UWMZ6HLFYUKAIVAy3YXaSN70kYhNuEHhN00IGwwuICM E7/Zd6GCAbcVkBA2h7yJ/ZKsttztRrY36/KvwrIo6MRbWFw= X-Google-Smtp-Source: ACHHUZ4NugLLUy9B0o0Cb9ktO5qc0yn6Xhks+JOwxnKU/bSkIVRB3isJGb0jLkBsn7SH7NSg+PuX8QBZ4ovunkfGNME= X-Received: by 2002:a17:907:2da7:b0:973:daa0:2e9 with SMTP id gt39-20020a1709072da700b00973daa002e9mr4223733ejc.13.1685232862168; Sat, 27 May 2023 17:14:22 -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: Aryeh Friedman Date: Sat, 27 May 2023 20:14:11 -0400 Message-ID: Subject: Re: What happened to my /tmp/mysql.sock ?!!??! To: Paul Procacci Cc: Odhiambo Washington , FreeBSD Mailing List Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable X-Rspamd-Queue-Id: 4QTK0H53Psz47XQ X-Spamd-Bar: ---- X-Spamd-Result: default: False [-4.00 / 15.00]; REPLY(-4.00)[]; ASN(0.00)[asn:15169, ipnet:2a00:1450::/32, country:US]; TAGGED_FROM(0.00)[] X-Rspamd-Pre-Result: action=no action; module=replies; Message is reply to one we originated X-ThisMailContainsUnwantedMimeParts: N On Sat, May 27, 2023 at 1:21=E2=80=AFPM Paul Procacci = wrote: > > > > 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 initializ= e 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 sta= rt. >> >> 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 i= n later versions of mysql. If that's the case then the following should in= itialize 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=3D270807 > > Once one of the two are completed, then you can try the things that Mr. W= ashington was suggesting and repost an new error messages. > > ~Paul > > -- > __________________ > > :(){ :|:& };: --=20 Aryeh M. Friedman, Lead Developer, http://www.PetiteCloud.org