Htykuut

I want to connect MySQL RDS DB using python from raspberrypi.(i want to get seq from MySQL table 'face' using select query.)

and I have an error but i can not fix it.

This is rds mysql connection code:

import rds_config

import pymysql



rds_host = rds_config.rds_host

name = rds_config.rds_user

password = rds_config.rds_pwd

db_name = rds_config.rds_db



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

connect_timeout=10)

with conn.cursor() as cur:

    cur.execute("select seq from face")

    conn.commit()

rds_config:

rds_host='rds endpoint'

rds_port=3306

rds_user='user'

rds_pwd='password'

rds_db='db name'

and This is traceback:

Traceback (most recent call last):

  File "getRds.py", line 18, in <module>

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

  File "/usr/local/lib/python2.7/dist-packages/pymysql/__init__.py", line 94, in Connect

    return Connection(*args, **kwargs)

  File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 327, in __init__

    self.connect()

  File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 598, in connect

    self._request_authentication()

  File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 862, in _request_authentication

    auth_packet = self._process_auth(plugin_name, auth_packet)

  File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 933, in _process_auth

    pkt = self._read_packet()

  File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 683, in _read_packet

    packet.check_error()

  File "/usr/local/lib/python2.7/dist-packages/pymysql/protocol.py", line 220, in check_error

    err.raise_mysql_exception(self._data)

  File "/usr/local/lib/python2.7/dist-packages/pymysql/err.py", line 109, in raise_mysql_exception

    raise errorclass(errno, errval)

pymysql.err.InternalError: (1049, u"Unknown database 'bsb-rds'")

i alread added ip address in vpc security group and public access is on.
it was possible to connect through mysql cli or workbench.

can anyone help me?