Quote:
Originally Posted by audioblivious
when i use :
SET PASSWORD FOR 'eqemu'@'localhost' = OLD_PASSWORD('hire');
i get this :#1133 - Can't find any matching row in the user table
when i use :mysql> UPDATE `user` SET Password=old_password('hire') WHERE Host='localhost' and User='eqemu';
i get this :#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysql> UPDATE `user` SET Password=old_password('hire') WHERE Host='localhost' an' at line 1
now what??
|
Error #1133: No such user, eqemu, is about all I can see for that.
Error #1064: Syntax. Note the difference in single quotes surrounding
user vs
hire/localhost/eqemu. (` vs '. Use '.)