Thread: perl problem
View Single Post
  #17  
Old 03-02-2008, 10:43 AM
audioblivious
Sarnak
 
Join Date: Sep 2002
Posts: 44
Default

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??
Reply With Quote