smf server : update user's password by SQL

[admin]

代碼 [選擇] Expand

UPDATE smf_members SET passwd = SHA1(CONCAT(LOWER('your_admin_username'), 'your_new_password')) WHERE ID_MEMBER = 1 OR member_name = 'your_admin_username';