For change password on new verions need modified (in my case -10.11.6-MariaDB)

[KasperWPS]

https://github.com/bertvv/scripts/blob/5583d014490efdcc43445031bf09dea9db5b9bc7/src/secure-mysql.sh#L77C44-L77C63

UPDATE mysql.global_priv SET Priv=json_set(priv, '$.plugin', 'mysql_native_password', '$.authentication_string', PASSWORD('${db_root_password}')) WHERE User='root';