Skip to content

ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'  #455

@WeirdPhrog

Description

@WeirdPhrog

Ubuntu 16.04.6, mysql 5.7.27, Mysqltuner 1.6.0
When I launch the script I get:
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'

With latest ver from github:
[!!] FAIL Execute SQL / return code: 256
[!!] failed to execute: SELECT CONCAT(user, '@', host) FROM mysql.user WHERE IF(plugin='mysql_native_password', authentication_string, password) = PASSWORD('steelers') OR
IF(plugin='mysql_native_password', authentication_string, password) = PASSWORD(UPPER('steelers')) OR IF(plugin='mysql_native_password', authentication_string, password) =
PASSWORD(CONCAT(UPPER(LEFT('steelers', 1)), SUBSTRING('steelers', 2, LENGTH('steelers'))))

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions