Return
-
Title
Error when checking password on MySQL 5.7.6 and above "Unknown column 'password' in 'field list'" -
Description
When attempting to "Check Password" on a MySQL 5.7.6 account the below error is shown:[DD/MM/YYYY HH:MM:SS] Gathering the check details for funcacct on mysql5.7...[DD/MM/YYYY HH:MM:SS] Checking the MySQL password for funcacct on mysql5.7...[DD/MM/YYYY HH:MM:SS] Error: [1054] [2] "[MySQL][ODBC 5.1 Driver][mysqld-5.7.12-log]Unknown column 'password' in 'field list'"[DD/MM/YYYY HH:MM:SS] Unable to check the password. Check the functional account privileges.[DD/MM/YYYY HH:MM:SS] Processed the password check for funcacct on mysql5.7 in x seconds -
Cause
From MySQL 5.7.6 the ‘password’ column has been removed. This means that TPAMs “Check Password” fails to work.http://dev.mysql.com/doc/relnotes/mysql/5.7/en/news-5-7-6.html -
Resolution
WORKAROUND: Support for MySQL 5.7.6+ has been added with TPAM Hotfix 8467 available here for TPAM versions 2.5.915-2.5.919
STATUS: BFER 8467 has been added in TPAM 2.5.920; from the TPAM 2.5.920 Release Notes under "Resolved Issue" section:
"TPAM not able to check password for newer versions of MySQL." IssueID 8467 -
Change Request
BFER 8467