<html><head><meta http-equiv="Content-Type" content="text/html; charset=us-ascii"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class="">I have a non-default location for the data dir with mysql8, namely, as specified in my.cnf:<div class=""><br class=""></div><div class=""><span class="Apple-tab-span" style="white-space:pre"> </span>datadir = /Users/me/Databases/mysql/data</div><div class=""><br class=""></div><div class="">What should the ownership of that directory, and its subdirectories and files, be? And with what permissions?</div><div class=""><br class=""></div><div class="">At the moment, for reasons I do not know, I have:</div><div class=""><br class=""></div><div class=""><span class="Apple-tab-span" style="white-space:pre"> </span>ls -ld /Users/me/Databases/mysql/data</div><div class=""><span class="Apple-tab-span" style="white-space:pre"> </span>drwxr-x--- 91 me staff 2912 Jun 18 10:18 /Users/me/Databases/mysql/data</div><div class=""><br class=""></div><div class="">And:</div><div class=""><br class=""></div><div class="">[~] % ls -l /Users/me/Databases/mysql/data </div><div class=""> total 709416 [partial listing]</div><div class=""> -rw-r----- 1 me staff 196608 Apr 6 10:04 #ib_16384_0.dblwr </div><div class="">-rw-r----- 1 me staff 8585216 Feb 4 12:45 #ib_16384_1.dblwr </div><div class="">drwxr-x--- 12 me staff 384 Apr 6 10:02 #innodb_temp </div><div class="">-rw-r----- 1 me staff 4982504 Oct 3 2020 mymac.local.err </div><div class="">-rw-r----- 1 me staff 4 Apr 6 10:02 mymac.pid </div><div class="">drwxr-x--- 23 me staff 736 Oct 3 2020 Math421Blog </div><div class="">-rw-r-----@ 1 me staff 56 Oct 25 2018 auto.cnf </div><div class="">-rw-r----- 1 me staff 179 Mar 7 22:47 binlog.003746 </div><div class="">: </div><div class="">-rw-r----- 1 me staff 864 Apr 6 10:02 binlog.index </div><div class="">-rw------- 1 me staff 1680 Jan 2 2020 ca-key.pem </div><div class="">-rw-r--r-- 1 me staff 1112 Jan 2 2020 ca.pem </div><div class="">-rw-r--r-- 1 me staff 1112 Jan 2 2020 client-cert.pem </div><div class="">-rw------- 1 me staff 1676 Jan 2 2020 client-key.pem </div><div class="">-rw-r----- 1 me staff 5175 Apr 5 23:15 ib_buffer_pool </div><div class="">-rw-r----- 1 me staff 50331648 Apr 6 10:04 ib_logfile0 </div><div class="">-rw-r----- 1 me staff 50331648 Feb 5 12:55 ib_logfile1 </div><div class="">-rw-r----- 1 me staff 79691776 Apr 6 21:01 ibdata1 </div><div class="">-rw-r----- 1 me staff 12582912 Apr 6 10:02 ibtmp1 </div><div class="">drwxr-x--- 8 me staff 256 Feb 4 12:45 mysql </div><div class="">-rw-r----- 1 me staff 46137344 Apr 6 10:02 mysql.ibd </div><div class="">-rw-r----- 1 me staff 6 Feb 4 12:45 mysql_upgrade_info </div><div class="">drwxr-x--- 111 me staff 3552 Feb 4 12:45 performance_schema </div><div class="">drwxr-x--- 21 me staff 672 Oct 3 2020 phpmyadmin </div><div class="">-rw------- 1 me staff 1680 Jan 2 2020 private_key.pem </div><div class="">-rw-r--r-- 1 me staff 452 Jan 2 2020 public_key.pem </div><div class="">drwxr-x--- 29 me staff 928 Oct 3 2020 sakila </div><div class="">-rw-r--r-- 1 me staff 1112 Jan 2 2020 server-cert.pem </div><div class="">-rw------- 1 me staff 1676 Jan 2 2020 server-key.pem </div><div class="">drwxr-x--- 3 me staff 96 Oct 3 2020 sys </div><div class="">-rw-r----- 1 me staff 80740352 Apr 6 10:04 undo_001 </div><div class="">-rw-r----- 1 me staff 29360128 Feb 5 21:01 undo_002</div><div class="">:</div><div class=""><br class=""></div><div class=""><span class="Apple-tab-span" style="white-space: pre;"> </span></div><div class=""><div class="">
<div style="color: rgb(0, 0, 0); letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class="">---<br class="">Murray Eisenberg<span class="Apple-tab-span" style="white-space: pre;"> </span><a href="mailto:murrayeisenberg@gmail.com" class="">murrayeisenberg@gmail.com</a><br class="">503 King Farm Blvd #101<span class="Apple-tab-span" style="white-space: pre;"> </span><br class="">Rockville, MD 20850-6667<span class="Apple-tab-span" style="white-space: pre;"> </span>Mobile (413)-427-5334<br class=""><br class=""></div>
</div>
<br class=""></div></body></html>