When I do
SELECT User, Host FROM mysql.user I see that I have a user named
%. 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...