How to connect to MariaDB directly

[subtle pagoda]

I am trying to connect to MariaDB by following this guide:
https://gist.github.com/byawitz/885510a4d9789e97424337e9472276d7
sadly when trying to connect using ssh the suername root and password toor do not work. I am getting the error:
Server closed connection during identification exchange
Where am i supposed to find the correct credentials?

[bold elbow]

those are example credentials. actual passwords for mariadb should be in your .env file.

[subtle pagoda]

yes but
Appwrite Server Username
and
Appwrite Server Password
are not found .env

[simple ridge]

It's
_APP_DB_USER
And
_APP_DB_PASS

[subtle pagoda]

the MariaDB user and password can be found in the .env

but not the credentials to connect through the ssh tunnel

which in the example are root and toor

What i mean is that we are talking about 2 different credentials
im asking for this

but youre giving me the answer to this:

[simple ridge]

It's a remote server?

The SSH credentials are not the DB and user password, but your machine

What's the program you're using to connect into the database?

[subtle pagoda]

nope its a docker container hosted locally

[subtle pagoda]

ah

[subtle pagoda]

using a plugin for webstorm

but also tried using tableplus

[subtle pagoda]

Ok nvm, i manged to expose the ports for the db and then connected to directly without using an ssh tunnel

[simple ridge]

If it's locally, why do you need an ssh tunnel?