[Sqlalchemy-tickets] Issue #3521: SQLAlchemy fails for MySQL 5.7.8 with a security error (zzzeek/sqlalchemy)

[Joseph S. <iss...@bi...>]

New issue 3521: SQLAlchemy fails for MySQL 5.7.8 with a security error
https://bitbucket.org/zzzeek/sqlalchemy/issues/3521/sqlalchemy-fails-for-mysql-578-with-a

Joseph Schorr:

Apologies if this has already been addressed; a search did not find any references.

On MySQL 5.7.8, trying to connect via SQLAlchemy results in the following exception:


```
#!python
sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) (1142, u"SELECT command denied to user 'testuser'@'192.168.59.3' for table 'session_variables'") [SQL: "SHOW VARIABLES LIKE 'sql_mode'"]
```

This exception is raised because of a recent security change made by Oracle to MySQL. Details on the issue and some possible solutions can be found here: http://code.openark.org/blog/mysql/baffling-5-7-globalstatus-variables-issues-unclean-migration-path

Is there a recommended approach to working around this issue?