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

#!/bin/sh CONTAINER=appwrite-mariadb PROJECT=<YOUR 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

TL;DR

The user is asking for the root password and the database name. They have set the password in the .env file and all SQL queries work, but they need the password for deleting. The user is also asking how to find the mapping of table names with internal table names. Solution: - The root password can be found in the .env file. - The database name can be found by looking into the tables. The table `_console_projects` has all the projects, with the `_id` being the prefix used for the project tables. The table `<prefix>_databases` will give you the databases, with the `_id

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.