From owner-freebsd-questions@freebsd.org Sun Mar 21 23:58:54 2021 Return-Path: Delivered-To: freebsd-questions@mailman.nyi.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2610:1c1:1:606c::19:1]) by mailman.nyi.freebsd.org (Postfix) with ESMTP id A56F9571C7F for ; Sun, 21 Mar 2021 23:58:54 +0000 (UTC) (envelope-from johnl@iecc.com) Received: from gal.iecc.com (gal.iecc.com [IPv6:2001:470:1f07:1126:0:43:6f73:7461]) (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 RSA-PSS (2048 bits) client-digest SHA256) (Client CN "gal.iecc.com", Issuer "Let's Encrypt Authority X3" (not verified)) by mx1.freebsd.org (Postfix) with ESMTPS id 4F3ZNF6MpTz4c6Q for ; Sun, 21 Mar 2021 23:58:53 +0000 (UTC) (envelope-from johnl@iecc.com) Received: (qmail 58473 invoked from network); 21 Mar 2021 23:58:46 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=simple; d=iecc.com; h=date:message-id:from:to:cc:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:cleverness; s=e465.6057ddb6.k2103; bh=DWMNF8VmeHFJvgwfDffuLriJAWNF6qT1KRh1XC+6/ro=; b=ZDqWduQFN82anXy1PxCNJjQUNmt4+IjZrkqPL99an7MC+T45GsZLLrJdHF4QT3CG9t6dU49SuZvFtvLHfSQQi3dPffZ1YCePkiEvM99NS+WV7OQnfNHJzkjtt4nbHMhngHBPEMKgxiSA3Q3PCboLoaynrswrum9riSiLvQcCRE+Ya1WfZtIG1KGtsPEWSsn5cLxThFVS1zuQ2GnSdOvaWdOVAYnxDG79LRhRb567Tt6mMZ4TzJalAPXPY19OlLNaPytVBUe37ZdZGNoH1m3dPXmKoepSjv6OZnQi2XPL3caD8DobrR/XNEgwcIV8DlOHzuYEBWiWaMtbrxmziN856A== Received: from ary.qy ([IPv6:2001:470:1f07:1126::78:696d:6170]) by imap.iecc.com ([IPv6:2001:470:1f07:1126::78:696d:6170]) with ESMTPS (TLS1.2 ECDHE-RSA AES-256-GCM AEAD) via TCP6; 21 Mar 2021 23:58:46 -0000 Received: by ary.qy (Postfix, from userid 501) id E3B5870DD030; Sun, 21 Mar 2021 19:58:45 -0400 (EDT) Date: 21 Mar 2021 19:58:45 -0400 Message-Id: <20210321235845.E3B5870DD030@ary.qy> From: "John Levine" To: freebsd-questions@freebsd.org Subject: Re: problems upgrading mysql 5.6 => 5.7 In-Reply-To: <48b6f3cd-d884-f414-d720-a94e8b27f3b1@dreamchaser.org> Organization: Taughannock Networks X-Headerized: yes Cleverness: minimal Mime-Version: 1.0 Content-type: text/plain; charset=utf-8 Content-transfer-encoding: 8bit X-Rspamd-Queue-Id: 4F3ZNF6MpTz4c6Q X-Spamd-Bar: --- Authentication-Results: mx1.freebsd.org; dkim=none (invalid DKIM record) header.d=iecc.com header.s=e465.6057ddb6.k2103 header.b=ZDqWduQF; dmarc=pass (policy=none) header.from=iecc.com; spf=pass (mx1.freebsd.org: domain of johnl@iecc.com designates 2001:470:1f07:1126:0:43:6f73:7461 as permitted sender) smtp.mailfrom=johnl@iecc.com X-Spamd-Result: default: False [-3.30 / 15.00]; RCVD_TLS_ALL(0.00)[]; ARC_NA(0.00)[]; NEURAL_HAM_MEDIUM(-1.00)[-1.000]; FROM_HAS_DN(0.00)[]; MV_CASE(0.50)[]; R_SPF_ALLOW(-0.20)[+ip6:2001:470:1f07:1126::/64]; MIME_GOOD(-0.10)[text/plain]; TO_DN_NONE(0.00)[]; NEURAL_HAM_LONG(-1.00)[-1.000]; HAS_ORG_HEADER(0.00)[]; SPAMHAUS_ZRD(0.00)[2001:470:1f07:1126:0:43:6f73:7461:from:127.0.2.255]; TO_MATCH_ENVRCPT_SOME(0.00)[]; DKIM_TRACE(0.00)[iecc.com:~]; RCPT_COUNT_TWO(0.00)[2]; DMARC_POLICY_ALLOW(-0.50)[iecc.com,none]; NEURAL_HAM_SHORT(-1.00)[-1.000]; R_DKIM_PERMFAIL(0.00)[iecc.com:s=e465.6057ddb6.k2103]; FROM_EQ_ENVFROM(0.00)[]; MIME_TRACE(0.00)[0:+]; RBL_DBL_DONT_QUERY_IPS(0.00)[2001:470:1f07:1126:0:43:6f73:7461:from]; RCVD_COUNT_TWO(0.00)[2]; ASN(0.00)[asn:6939, ipnet:2001:470::/32, country:US]; MAILMAN_DEST(0.00)[freebsd-questions] X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.34 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sun, 21 Mar 2021 23:58:54 -0000 It appears that Gary Aitken said: >$ cat ~/.my.cnf: >[mysqld] >datadir=/hd2/home/me/mysql_data >tmpdir=/hd2/home/me/tmp >innodb_strict_mode=on > >The data directory is writable by the user starting mysqld, as are all of the files in it: > >$ ls -l >-rw------- 1 me me 56 Oct 15 2016 auto.cnf >-rw-r----- 1 me me 10040 Mar 21 12:47 breakaway.dreamchaser.org.err >-rw------- 1 me me 5 Jan 7 2020 breakaway.pid >-rw------- 1 me me 50331648 Feb 6 2020 ib_logfile0 >-rw------- 1 me me 50331648 Oct 15 2016 ib_logfile1 >-rw------- 1 me me 27262976 Feb 6 2020 ibdata1 >drwx------ 2 me me 2560 Oct 15 2016 mysql >-rw------- 1 me me 0 Feb 8 2020 mysql-bin.index >-rw------- 1 me me 6 Oct 15 2016 mysql_upgrade_info >drwx------ 2 me me 2560 Oct 15 2016 performance_schema > >The system directory /var/db/mysqld exists and is owned/writeable by the mysql user, as are all of the files in it. If you're using the mysql-server package, Mysql runs as the mysql user, user ID 88, and all of its data files should belong to mysql. Unless you really REALLY know what you are doing, nothing but mysql should be writing the files in its database directory so nobody else should have write access to it.