mysql - Why don't I have access to the database from aws lambda but have from a local computer with the same login data?

Question

I created a new Mysql database in Amazon RDS, and on my local computer I get access through the console

mysql -u username -p -h test.c2nfdg67dbdpb.us-east-1.rds.amazonaws.com

Now I try to connect via Aws Lamda using python and pymysql module

rds_host  = "test.c2nfdg67dbdpb.us-east-1.rds.amazonaws.com"
name = 'username'
password = 'pass'
db_name = 'dbtest'

conn = pymysql.connect(rds_host, user=name, passwd=password, db=db_name, connect_timeout=5)

and got an error ERROR] 2019-11-20T14:30:05.261Z 7b1ed2e0-03ba-4c62-9525-22d84582f (1049, "Unknown database 'dbtest'")

It seems strange that I don't use the database name at all through the local console and I get access.

p.s.I run show databases; on local console and cant see dbtest in databaselist. I was confused because when I created the new database, I entered a name, but only default databases are listed. What am I connected to then?

p.s.s hm why DB name is undefined ?

Answer 1

Your code explicitly tries to connect a specific database named dbtest. It will either connect to this database or fail, contrary to your mysql client which can connect without a database selection. Clearly, the database is missing, since you verified that show databases results does not include dbtest.

Then only possible explanation is that the database was never created.