Date: 21 Mar 2021 19:58:45 -0400 From: "John Levine" <johnl@iecc.com> To: freebsd-questions@freebsd.org Subject: Re: problems upgrading mysql 5.6 => 5.7 Message-ID: <20210321235845.E3B5870DD030@ary.qy> In-Reply-To: <48b6f3cd-d884-f414-d720-a94e8b27f3b1@dreamchaser.org>
next in thread | previous in thread | raw e-mail | index | archive | help
It appears that Gary Aitken <freebsd@dreamchaser.org> 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.
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20210321235845.E3B5870DD030>