I'm trying to connect to mysql using below
engine = create_engine("mysql+pymysql://user:pwd@localhost/test")
connection = engine.connect()
it works while in local and when deployed the code in one of our linux box
, am getting
sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) (2003,
"Can't connect to MySQL server on 'xxx.xx.xx.xxx' ([Errno 13] Permission
denied)")
I checked the user privileges and the user has all the necessary privileges.
using the same user and am able to connect from python terminal from the
same linux box but it doesnt work using the python code.
Any suggestions if am missing anything?
--
SQLAlchemy -
The Python SQL Toolkit and Object Relational Mapper
http://www.sqlalchemy.org/
To post example code, please provide an MCVE: Minimal, Complete, and Verifiable
Example. See http://stackoverflow.com/help/mcve for a full description.
---
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to sqlalchemy+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/sqlalchemy/d70ac922-857f-426a-aca2-81940327575do%40googlegroups.com.
