I can't remember the ID and name of Maria db.

Question

I'm using an instance as an Amazon LightSail Ubuntu.
But I can't remember Maria db's name and ID. I only remember the password. Please tell me how to check the db name and ID.

Accepted Answer

Once you're logged into the MariaDB command line, you can list all databases with the following SQL command:

```
SHOW DATABASES;

```

This will show you a list of all the databases on your MariaDB instance.

To list all users, you can use the following SQL command:

```
SELECT User,Host FROM mysql.user;

```

This will show you a list of all the user IDs and the hosts they're associated with.

I can't remember the ID and name of Maria db.

Conteúdo relevante