> 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.
When this works in the terminal, how are you connecting? In Python via the database driver, or using the mysql client? If it's the mysql client, check the server's mysql and system/auth logs. The mysql instance might not be configured to allow this type of connection/authentication from the user. -- 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/d91a42f0-80e8-4431-8882-eaeb29d7ffc9o%40googlegroups.com.