Cannot Create User with Security Manager when MySQL Password Validation Policy is enabled

Discussion of open issues, suggestions and bugs regarding database management and administration tools for MySQL
Post Reply
lieszkol
Posts: 4
Joined: Sun 15 Jul 2018 07:56

Cannot Create User with Security Manager when MySQL Password Validation Policy is enabled

Post by lieszkol » 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):

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?

alexa
Devart Team
Posts: 2792
Joined: Fri 24 Jun 2011 14:17

Re: Cannot Create User with Security Manager when MySQL Password Validation Policy is enabled

Post by alexa » Tue 17 Jul 2018 07:18

We will investigate this issue and will answer you as soon as possible.

Post Reply