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?

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.