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

0

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.

已提问 1 年前183 查看次数
1 回答
1
已接受的回答

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.

profile picture
专家
已回答 1 年前

您未登录。 登录 发布回答。

一个好的回答可以清楚地解答问题和提供建设性反馈,并能促进提问者的职业发展。

回答问题的准则