I have been getting this issue:
Client does not support authentication protocol requested
by server; consider upgrading MySQL client
I know it's the old password hashing problem, so I have run these commands as they have solved this problem before:
SET PASSWORD FOR 'root'@'localhost' = OLD_PASSWORD('newpwd');
Alternatively, use UPDATE and FLUSH PRIVILEGES:
UPDATE mysql.user SET Password = OLD_PASSWORD('newpwd')
WHERE Host = 'localhost' AND User = 'root'; FLUSH PRIVILEGES;
This time it didn't work
Client does not support authentication protocol requested
by server; consider upgrading MySQL client
I know it's the old password hashing problem, so I have run these commands as they have solved this problem before:
SET PASSWORD FOR 'root'@'localhost' = OLD_PASSWORD('newpwd');
Alternatively, use UPDATE and FLUSH PRIVILEGES:
UPDATE mysql.user SET Password = OLD_PASSWORD('newpwd')
WHERE Host = 'localhost' AND User = 'root'; FLUSH PRIVILEGES;
This time it didn't work
