mysql8 data dir owner and permissions?

[Murray Eisenberg]

I have a non-default location for the data dir with mysql8, namely, as specified in my.cnf:

	datadir = /Users/me/Databases/mysql/data

What should the ownership of that directory, and its subdirectories and files, be? And with what permissions?

At the moment, for reasons I do not know, I have:

	ls -ld /Users/me/Databases/mysql/data
	drwxr-x--- 91 me  staff 2912 Jun 18 10:18 /Users/me/Databases/mysql/data

And:

[~] % ls -l /Users/me/Databases/mysql/data 
 total 709416 [partial listing]
 -rw-r----- 1 me staff 196608 Apr 6 10:04 #ib_16384_0.dblwr 
-rw-r----- 1 me staff 8585216 Feb 4 12:45 #ib_16384_1.dblwr 
drwxr-x--- 12 me staff 384 Apr 6 10:02 #innodb_temp 
-rw-r----- 1 me staff 4982504 Oct 3 2020 mymac.local.err 
-rw-r----- 1 me staff 4 Apr 6 10:02 mymac.pid 
drwxr-x--- 23 me staff 736 Oct 3 2020 Math421Blog 
-rw-r-----@ 1 me staff 56 Oct 25 2018 auto.cnf 
-rw-r----- 1 me staff 179 Mar 7 22:47 binlog.003746 
: 
-rw-r----- 1 me staff 864 Apr 6 10:02 binlog.index 
-rw------- 1 me staff 1680 Jan 2 2020 ca-key.pem 
-rw-r--r-- 1 me staff 1112 Jan 2 2020 ca.pem 
-rw-r--r-- 1 me staff 1112 Jan 2 2020 client-cert.pem 
-rw------- 1 me staff 1676 Jan 2 2020 client-key.pem 
-rw-r----- 1 me staff 5175 Apr 5 23:15 ib_buffer_pool 
-rw-r----- 1 me staff 50331648 Apr 6 10:04 ib_logfile0 
-rw-r----- 1 me staff 50331648 Feb 5 12:55 ib_logfile1 
-rw-r----- 1 me staff 79691776 Apr 6 21:01 ibdata1 
-rw-r----- 1 me staff 12582912 Apr 6 10:02 ibtmp1 
drwxr-x--- 8 me staff 256 Feb 4 12:45 mysql 
-rw-r----- 1 me staff 46137344 Apr 6 10:02 mysql.ibd 
-rw-r----- 1 me staff 6 Feb 4 12:45 mysql_upgrade_info 
drwxr-x--- 111 me staff 3552 Feb 4 12:45 performance_schema 
drwxr-x--- 21 me staff 672 Oct 3 2020 phpmyadmin 
-rw------- 1 me staff 1680 Jan 2 2020 private_key.pem 
-rw-r--r-- 1 me staff 452 Jan 2 2020 public_key.pem 
drwxr-x--- 29 me staff 928 Oct 3 2020 sakila 
-rw-r--r-- 1 me staff 1112 Jan 2 2020 server-cert.pem 
-rw------- 1 me staff 1676 Jan 2 2020 server-key.pem 
drwxr-x--- 3 me staff 96 Oct 3 2020 sys 
-rw-r----- 1 me staff 80740352 Apr 6 10:04 undo_001 
-rw-r----- 1 me staff 29360128 Feb 5 21:01 undo_002
:

	
---
Murray Eisenberg			murrayeisenberg at gmail.com
503 King Farm Blvd #101	
Rockville, MD 20850-6667	Mobile (413)-427-5334


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macports.org/pipermail/macports-users/attachments/20210618/19dd5fdb/attachment.htm>