[Sqlalchemy-tickets] Issue #3521: SQLAlchemy fails for MySQL 5.7.8 with a security error (zzzeek/sq
Brought to you by:
zzzeek
|
From: Joseph S. <iss...@bi...> - 2015-08-31 19:57:33
|
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? |