Unable to import module 'lambda_function': No module named 'mysql'

Question

I'm trying to send data to a MySQL database hosted on AWS' RDS using a Lambda function. However, when I try to import the mysql module with import mysql.connector I get a "Runtime.ImportModuleError" error.

I've tried finding a python file for the mysql.connector online to upload to the function with no luck.

import mysql.connector

def lambda_handler(event, context):
    mydb = mysql.connector.connect(
            host="test.url.us-west-2.rds.amazonaws.com",
            user="root",
            passwd="password",
            database="test")

     mycursor = mydb.cursor()
     sql = "INSERT INTO table VALUES ('test')"
     mycursor.execute(sql)

     mydb.commit()
     return {
        status: 'success'
     }

I would like to successfully execute the SQL command above to the remote RDS database. But I keep getting "Unable to import module 'lambda_function': No module named 'mysql'"

kungphu · Accepted Answer · 2019-07-24 03:29:49Z

1

When deploying a Python function to AWS Lambda, you need to bundle your dependencies with your Python file(s).

If your function depends on libraries other than the SDK for Python (Boto 3), install them to a local directory with pip, and include them in your deployment package.

answered Jul 24, 2019 at 3:29

kungphu

4,8613 gold badges30 silver badges38 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Unable to import module 'lambda_function': No module named 'mysql'

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related