[TIP] How to change username (and password) via SQL

[Yehonal]

Sometimes, you want to change a username via the DB. To do it properly you also need to re-hash the password and reset the session keys.

Here you are the query...replace <your-user>, <your-pass> and <your-id> with your information

  UPDATE `account` SET 
  `username` = '<your-user>', 
  `sha_pass_hash` = SHA1(CONCAT(UPPER('<your-user>'),':',UPPER('<your-pass>'))), 
  `v` = '0' , `s` = '0' ,`sessionkey` = '0'  
  WHERE `id` = <your-id>;