Cannot Create User with Security Manager when MySQL Password Validation Policy is enabled
Posted: Sun 15 Jul 2018 08:04
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):
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:
Am I really the first person to notice this or am I just missing something obvious?
Code: Select all
CREATE USER 'XXX'@'localhost' IDENTIFIED WITH sha256_password PASSWORD EXPIRE NEVER;
ALTER USER 'XXX'@'localhost' IDENTIFIED BY 'XXXXXXXXXXXXXX';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';