Change email password
INSERT INTO `mailserver`.`virtual_users`
(`domain_id`, `password` , `email`)
VALUES
('5', ENCRYPT('newpassword', CONCAT('$6/r>, SUBSTRING(SHA(RAND()), -16))) , 'email3@newdomain.com');
Maybe like this:
UPDATE `mailserver`.`virtual_users`
SET password=ENCRYPT('newpassword2', CONCAT('$6/r>, SUBSTRING(SHA(RAND()), -16)))
WHERE email='email3@newdomain.com';
2 Replies
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.