0

When I do SELECT User, Host FROM mysql.user I see that I have a user named myuser on %. I tried setting that users password thusly:

SET PASSWORD FOR 'myuser'@'%' = 'mypassword';

Doing so, however, resulted in this error:

Error Code: 1133. Can't find any matching row in the user table

Superficially this sounds like Error Code: 1133. Can't find any matching row in the user table but it's not the same because the username and password do appear to exist...

Any ideas?

Improve this question
2
  • Are you using 'native' passwords, or some other plugin?
    – Rick James
    Commented Feb 19, 2019 at 17:26
  • Use ALTER USER, not SET PASSWORD. Test user name/host values using HEX() function.
    – Akina
    Commented Feb 20, 2019 at 5:04

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.