Collectives™ on Stack Overflow

Find centralized, trusted content and collaborate around the technologies you use most.

Teams

Q&A for work

Connect and share knowledge within a single location that is structured and easy to search.

sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) ([Errno 13] Permission denied)")

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?
                Are you using the exact same credentials (username and password) when connecting to the two different machines?
– Gord Thompson
                Aug 18, 2020 at 16:59
        
Thanks for contributing an answer to Stack Overflow!
Please be sure to answer the question. Provide details and share your research!
But avoid …
Asking for help, clarification, or responding to other answers.
Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.