Database permissions

database-permissions.sh

$ for image in mysql:8 postgres:12 cassandra:3; do database=$(echo $image | cut -d ":" -f 1); docker exec -ti $(docker run -d  --name=$database -e MYSQL_ROOT_PASSWORD=ohai -e POSTGRES_PASSWORD=ohai $image) bash -c "echo ---- $database ----; sleep 5 && ls -lha /var/lib | grep ${database} && ls -lha /var/lib/${database}*" && echo -e "\n"; (docker stop $database; docker rm $database) >/dev/null; done


---- mysql ----
drwxrwxrwt 6 mysql mysql 4.0K Mar 22 10:00 mysql
total 184M

-rw-r----- 1 mysql mysql 192K Mar 22 10:00 '#ib_16384_0.dblwr'
-rw-r----- 1 mysql mysql 8.2M Mar 22 10:00 '#ib_16384_1.dblwr'
drwxr-x--- 2 mysql mysql 4.0K Mar 22 10:00 '#innodb_temp'
drwxrwxrwt 6 mysql mysql 4.0K Mar 22 10:00  .
drwxr-xr-x 1 root  root  4.0K Mar 18 08:06  ..
-rw-r----- 1 mysql mysql   56 Mar 22 10:00  auto.cnf
-rw------- 1 mysql mysql 1.7K Mar 22 10:00  ca-key.pem
-rw-r--r-- 1 mysql mysql 1.1K Mar 22 10:00  ca.pem
-rw-r--r-- 1 mysql mysql 1.1K Mar 22 10:00  client-cert.pem
-rw------- 1 mysql mysql 1.7K Mar 22 10:00  client-key.pem
-rw-r----- 1 mysql mysql  48M Mar 22 10:00  ib_logfile0
-rw-r----- 1 mysql mysql  48M Mar 22 10:00  ib_logfile1
-rw-r----- 1 mysql mysql  12M Mar 22 10:00  ibdata1
-rw-r----- 1 mysql mysql  12M Mar 22 10:00  ibtmp1
drwxr-x--- 2 mysql mysql 4.0K Mar 22 10:00  mysql
-rw-r----- 1 mysql mysql  23M Mar 22 10:00  mysql.ibd
drwxr-x--- 2 mysql mysql 4.0K Mar 22 10:00  performance_schema
-rw------- 1 mysql mysql 1.7K Mar 22 10:00  private_key.pem
-rw-r--r-- 1 mysql mysql  452 Mar 22 10:00  public_key.pem
-rw-r--r-- 1 mysql mysql 1.1K Mar 22 10:00  server-cert.pem
-rw------- 1 mysql mysql 1.7K Mar 22 10:00  server-key.pem
drwxr-x--- 2 mysql mysql 4.0K Mar 22 10:00  sys
-rw-r----- 1 mysql mysql  16M Mar 22 10:00  undo_001
-rw-r----- 1 mysql mysql  16M Mar 22 10:00  undo_002


---- postgres ----
drwxr-xr-x 1 postgres postgres 4.0K Oct 12 12:19 postgresql
total 12K

drwxr-xr-x  1 postgres postgres 4.0K Oct 12 12:19 .
drwxr-xr-x  1 root     root     4.0K Oct 12 12:18 ..
drwx------ 19 postgres postgres 4.0K Mar 22 10:01 data


---- cassandra ----
drwxrwxrwx 6 cassandra cassandra 4.0K Mar 22 10:01 cassandra
total 24K

drwxrwxrwx 6 cassandra cassandra 4.0K Mar 22 10:01 .
drwxr-xr-x 1 root      root      4.0K Mar  7 20:09 ..
drwxr-xr-x 2 cassandra cassandra 4.0K Mar 22 10:01 commitlog
drwxr-xr-x 4 cassandra cassandra 4.0K Mar 22 10:01 data
drwxr-xr-x 2 cassandra cassandra 4.0K Mar 22 10:01 hints
drwxr-xr-x 2 cassandra cassandra 4.0K Mar 22 10:01 saved_caches