FAIL Execute SQL / return code: 256

jlucho

Well-Known Member
Aug 5, 2006
60
1
158
hi guys

I'm optimizing mysql with "perl /sbin/mysqltuner.pl"

when executing this script, it generates an alert message

[!!] 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('freddy') OR IF(plugin='mysql_native_password', authentication_string, password) = PASSWORD(UPPER('freddy')) OR IF(plugin='mysql_native_password', authentication_string, password) = PASSWORD(CONCAT(UPPER(LEFT('freddy', 1)), SUBSTRING('freddy', 2, LENGTH('freddy'))))

[!!] 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('maxwell') OR IF(plugin='mysql_native_password', authentication_string, password) = PASSWORD(UPPER('maxwell')) OR IF(plugin='mysql_native_password', authentication_string, password) = PASSWORD(CONCAT(UPPER(LEFT('maxwell', 1)), SUBSTRING('maxwell', 2, LENGTH('maxwell'))))


How can this error message be fixed?
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,911
2,234
363
Hello @jlucho,

Do you notice any specific output to the MySQL error log (e.g. /var/lib/mysql/$hostname.err) when this happens?

Thank you.