UPDATE `accounts` SET `password` = SHA1( 'NEWPASSHERE' ) WHERE `name` = 'ACCNAMEHERE';
Well, Modern AAC does not support plain passwords and I just remembered that Gesior AAC reads it from the config.lua. So if you are using Modern AAC, you would have to code it yourself as it is not there by default.