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

Sami Ketola
2017-08-15T10:03:26Z

> 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