Update Passwords Wth MYSQL


Update MYSQL Passwords

UPDATE PASSWORDS WITH MYSQL

Using mysql password function
update tablename  set password=password('mypass') where id=9;

Update MD5 Passwords
update tablename  set password=md5('mypass') where id=9;

Update sha1 Passwords
update tablename  set password=sha1('mypass') where id=9;