appwrite-maraidb: What is the root password and whats the database-name? Is project important?

#!/bin/sh
CONTAINER=appwrite-mariadb
PROJECT=

docker exec -it $CONTAINER sh -c 'mysql -uroot -p$MYSQL_ROOT_PASSWORD $MYSQL_DATABASE -e "select permissions, documentSecurity, attributes FROM $1__metadata where _uid = "functions";"' -- $PROJECT

by default, these values are already set in your mariadb container as env vars

@Steven THX. how do I find the mapping of my table names with the internal table names?

you'll have to dig into the tables. for example, _console_projects has all the projects and the _id is the prefix used for the project tables. <prefix>_databases will give you the databases and the _id is the prefix used for the database tables. etc.

THX Steven. I got the logic.

all SQL queries work but for "delete" a password must be entered. Where can I get the root password?

You set the password in the .env file