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

preguntada hace un año670 visualizaciones
4 Respuestas
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
EXPERTO
respondido hace un año
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
EXPERTO
respondido hace un año
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

respondido hace un año
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
EXPERTO
respondido hace un año

No has iniciado sesión. Iniciar sesión para publicar una respuesta.

Una buena respuesta responde claramente a la pregunta, proporciona comentarios constructivos y fomenta el crecimiento profesional en la persona que hace la pregunta.

Pautas para responder preguntas