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 年前

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南