migrating 2.1 to 3.x, sql pass scheme, pass value?

Sami Ketola sami.ketola at dovecot.fi
Tue Aug 15 13:03:26 EEST 2017


> On 15 Aug 2017, at 2.50, voytek at sbt.net.au wrote:
> 
> how do I generate hashed string from my password ?

use this sql command: 

GRANT SELECT ON vmail TO ‘vmail’@‘127.0.0.1’ IDENTIFIED BY PASSWORD(‘yourpassword’);

or if you just want to see the hash:

SELECT PASSWORD(‘yourpassword’);

Sami



More information about the dovecot mailing list