From nobody Mon Apr 27 20:24:15 2026 X-Original-To: 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 4g4FR76Jp4z6bZJx for ; Mon, 27 Apr 2026 20:24:35 +0000 (UTC) (envelope-from freebsd@gushi.org) Received: from prime.gushi.org (prime.gushi.org [IPv6:2620:137:6000:10::142]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest SHA256 client-signature ECDSA (secp384r1) client-digest SHA384) (Client CN "prime.gushi.org", Issuer "E8" (not verified)) by mx1.freebsd.org (Postfix) with ESMTPS id 4g4FR72C0lz3P4M for ; Mon, 27 Apr 2026 20:24:35 +0000 (UTC) (envelope-from freebsd@gushi.org) Authentication-Results: mx1.freebsd.org; none Received: from smtpclient.apple (not.afront.org [50.126.75.182]) (authenticated bits=0) by prime.gushi.org (8.18.2/8.18.2) with ESMTPSA id 63RKOQLJ004599 (version=TLSv1.2 cipher=ECDHE-ECDSA-AES256-GCM-SHA384 bits=256 verify=NOT); Mon, 27 Apr 2026 20:24:27 GMT (envelope-from freebsd@gushi.org) DKIM-Filter: OpenDKIM Filter v2.10.3 prime.gushi.org 63RKOQLJ004599 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gushi.org; s=prime2014; t=1777321467; bh=YsyXpd7+2zkuNjuFZ8k9b2+i5X0TTs25jD3JhjhjAAI=; h=Subject:From:In-Reply-To:Date:Cc:References:To; z=Subject:=20Re:=20HELP!=20mysql-server=20broken=20on=20FreeBSD=201 3=20Release=20p12|From:=20"Dan=20Mahoney=20(Ports)"=20|In-Reply-To:=20|Date:=20Mon,=2027=20Apr=202026=2013:24:1 5=20-0700|Cc:=20questions@freebsd.org|References:=20|To:=20Willi am=20Dudley=20; b=RDMQyOaeFTM76npxJpsNXQi/roKEpOPhULinn9B86WzSqc1sG45dPVJ/8VIOT0gkt 5JYrVvNiw1dsXsjYPU+z+wrIekPDEoFEWHUrs1LGNn2HIuF9h3esnVhjIcyFLLJNLd Tqnwf2Nn1sL+6P8rudRjrDLU0RHBITk/Ions9USW/Q+CBjIZwrVOicE7XLa5d0rS2K 9haccVYcND+VTCeD+knjEvyaySQIeY/BgP5M9DsTFL+6Mgu+jFwja8oLROTiHcRB++ zTNXsVHQhsGq/00ptjL1VDOuH0B+mrZ4jbr9VHgCtzKkuNiYr+ELzKDah1VNhrbElr YrMfxrK7HnBbg== X-Authentication-Warning: prime.gushi.org: Host not.afront.org [50.126.75.182] claimed to be smtpclient.apple Content-Type: text/plain; charset=utf-8 List-Id: User questions List-Archive: https://lists.freebsd.org/archives/freebsd-questions List-Help: List-Post: List-Subscribe: List-Unsubscribe: X-BeenThere: freebsd-questions@freebsd.org Sender: owner-freebsd-questions@FreeBSD.org Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3864.500.181\)) Subject: Re: HELP! mysql-server broken on FreeBSD 13 Release p12 From: "Dan Mahoney (Ports)" In-Reply-To: Date: Mon, 27 Apr 2026 13:24:15 -0700 Cc: questions@freebsd.org Content-Transfer-Encoding: quoted-printable Message-Id: References: To: William Dudley X-Mailer: Apple Mail (2.3864.500.181) X-Greylist: Sender succeeded SMTP AUTH, not delayed by milter-greylist-4.6.4 (prime.gushi.org [149.20.68.142]); Mon, 27 Apr 2026 20:24:27 +0000 (UTC) X-Rspamd-Pre-Result: action=no action; module=replies; Message is reply to one we originated X-Spamd-Result: default: False [-4.00 / 15.00]; REPLY(-4.00)[]; ASN(0.00)[asn:393507, ipnet:2620:137:6000::/44, country:US] X-Rspamd-Queue-Id: 4g4FR72C0lz3P4M X-Spamd-Bar: ---- > On Apr 27, 2026, at 1:10=E2=80=AFPM, William Dudley = wrote: >=20 > During a recent pkg upgrade, pkg uninstalled my mysql server. I saw = that, but I figured > that some other thing had happened so I'd still have mysql running. = HAH! > I rebooted the machine last night, and the running instance of = mysql80-server > obviously disappeared. >=20 > I installed mysql84-server, but it fails, and mysql-client complains: > ERROR 1524 (HY000): Plugin 'mysql_native_password' is not loaded > The fix for this seems to involve having a running mysql server. This is a version of password authentication that's going away in future = versions of MySQL and did not survive the fork to MariaDB, and is = presently off by default. If you don't have your database passwords and = cannot re-password them, at least mysql84 and earlier have this option = you can set in my.cnf, but this is a compatibility shim and you should = move to something newer as soon as you can. Try this, and see what's in your error log after? [mysqld] mysql_native_password=3DON -Dan=