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;