Change email password

How to go about changing email passwords based on them being setup with this tutorial? … -addresses">

INSERT INTO `mailserver`.`virtual_users`
  (`domain_id`, `password` , `email`)
  ('5', ENCRYPT('newpassword', CONCAT('$6/r>, SUBSTRING(SHA(RAND()), -16))) , '');

Maybe like this:

UPDATE `mailserver`.`virtual_users`
SET password=ENCRYPT('newpassword2', CONCAT('$6/r>, SUBSTRING(SHA(RAND()), -16)))
WHERE email='';

2 Replies

I ran this on one email and was able to then login via roundcube to test it. Figured it worked, so I ran it on three other emails. Now I can't access any of them via roundcube or email clients like mailbird/outlook. I think I broke something.

Mail log is showing "Warning: mysql: Query failed, retrying: MySQL server has gone away", "warning: dictnisinit: NIS domain name not set - NIS lookups disabled".

Not sure how editing the email account passwords would make mysql issue. The password used for the account lookups wasn't changed.

I can connect via mysql workbench using mailserver user and see all the email accounts and aliases fine.

Rebooted and back in business. I think I was banned from fail2ban and the connection attempts.


Please enter an answer

You can mention users to notify them: @username

You can use Markdown to format your question. For more examples see the Markdown Cheatsheet.

> I’m a blockquote.

I’m a blockquote.

[I'm a link] (

I'm a link

**I am bold** I am bold

*I am italicized* I am italicized

Community Code of Conduct