Aws rds mysql connection issue from local nodejs application

0

while trying to connect aws mysql from nodejs application in my local windows 10 machine, getting following error

Error: ER_BAD_DB_ERROR: Unknown database 'mysqldatabasebane1' code: 'ER_BAD_DB_ERROR', errno: 1049, sqlMessage: "Unknown database 'mysqldatabasebane1' '", sqlState: '42000', fatal: true }

Also in my aws console i see database name is empty in one place.

Enter image description here

已提问 1 年前670 查看次数
4 回答
0

When creating RDS MySQL, if "Database Name" is not entered, the schema will not be created.
Connect to RDS MySQL and run the following command to create the schema.

CREATE DATABASE mysqldatabasebane1;
profile picture
专家
已回答 1 年前
0

Above will help. The problem was that as you did not specify it during creation, AWS will not create a database, so you ll have to do that later, as suggested above. Enter image description here

Hope it clarifies ;)

profile picture
专家
已回答 1 年前
0

I specified database name at the time of creation, the name is perfectly appearing on places like "DB identifier", "DB instance ID" etc.

if you look at the attached screenshot, you see the specified name "mysqldatabasebane1" in green color, but under "DB Name" label the name is not appearing.

while trying to connect from my local nodejs application, getting following error.

Error: ER_BAD_DB_ERROR: Unknown database 'mysqldatabasebane1' code: 'ER_BAD_DB_ERROR', errno: 1049, sqlMessage: "Unknown database 'mysqldatabasebane1' '", sqlState: '42000', fatal: true

when connecting local db, things are working fine.

Enter image description here

已回答 1 年前
0

You have entered mysqldatabasebane1 in the "DB instance identifier" field.
Open the "Additional Settings" at the bottom of the creation and enter "mysqldatabasebane1" in the "First Database Name" field.
Then mysqldatabasebane1 is created

profile picture
专家
已回答 1 年前

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

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

回答问题的准则