Trying to troubleshoot/understand mysqltuner JSON error message

49 Views Asked by At

As per name I am just an old git who is attempting to teach himself so apologies if this is the wrong place/query for here.

Anyway I have run mysqltuner and am working through the recommendations - some are easier and more obvious, some I've managed to solve with a little research but this one stumps me.

Can someone point me in the right direction for some literature/solution.

Thanks in advance

failed to execute: SELECT CONCAT(QUOTE(user), '@', QUOTE(host)) FROM mysql.global_priv WHERE
    user != ''
    AND JSON_CONTAINS(Priv, '"mysql_native_password"', '$.plugin') AND JSON_CONTAINS(Priv, '""', '$.authentication_string')
    AND NOT JSON_CONTAINS(Priv, 'true', '$.account_locked')
[!!] FAIL Execute SQL / return code: 256

No idea where to start as google doesn't return anything specific

0

There are 0 best solutions below