Using the "Security Manager" it is impossible to create a new user (at least on MySQL v8) when the Mysql password validation policy is enabled, because DBForge generates scripts as follows (replace "XXX" with a valid username and password):
Code: Select all
CREATE USER 'XXX'@'localhost' IDENTIFIED WITH sha256_password PASSWORD EXPIRE NEVER;
ALTER USER 'XXX'@'localhost' IDENTIFIED BY 'XXXXXXXXXXXXXX';
Of course MySQL throws a "Your password does not satisfy the current policy requirements" after the first statement.
Solution: the tool should generate the same script that is included in the "CREATE USER" snippet, where it all goes in one statement. Something along these lines:
Code: Select all
CREATE USER 'XXX'@'localhost' IDENTIFIED WITh mysql_native_password BY 'XXXXXXXXXXXX';
Am I really the first person to notice this or am I just missing something obvious?