#1133 – Can’t find any matching row in the user table (user table)

SET PASSWORD FOR 'johnny'@'localhost' = PASSWORD('somepassword69')

Mensagens do MySQL :

#1133 - Can't find any matching row in the user table (user table)

How to solve it? Before the SET PASSWORD try to run FLUSH PREVILEGES.
FLUSH PREVILEGES;
SET PASSWORD FOR 'johnny'@'localhost' = PASSWORD('somepassword69');
FLUSH PREVILEGES;

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.