Mysql password reset for admin

[itlinux]

ok this works:

update phplist_admin SET password=‘mynewpasswordworks’ where id = 1;