Bug #86064 Entering wrong password during Forward Engineer... isn't correctly handled
Submitted: 25 Apr 2017 0:33 Modified: 31 May 2019 18:23
Reporter: J Scavok Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench Severity:S3 (Non-critical)
Version: 6.3.9 CE build 10690321 (64 bit) OS:Any
Assigned to: CPU Architecture:Any
Tags: forward engineer, password

[25 Apr 2017 0:33] J Scavok
Description:
After entering an incorrect password while performing a Forward Engineer... operation, you're asked to re-enter the password at the wrong page (or step) and time.

How to repeat:
1. Open or create an EER diagram.

2. Select Database -> Forward Engineer...

3. Click Next twice in succession to advance to the page (or step) where the "Connect to MySQL Server" pop-up appears, asking you to "Please enter password for the following service:"

Beneath this pop-up window is the page (or step) titled "Select Objects to Forward Engineer". It is important to note that the appearance of the password pop-up prevents the underlying buttons, namely Back, Next, and Cancel, from being active; that is, you're not permitted to continue until you enter the correct password.

4. Enter an incorrect password. 

As expected, a new pop-up appears (titled "MySQL Workbench") with the contents:

Error connecting to database;
Access denied for user 'root'@'localhost' (using password: YES)

Click the OK button.

5. At this point the behavior isn't correctly handled. Why? Because the previously underlying, inactive page, "Select Objects to Forward Engineer" is now active and the user may now select Back, Next, or Cancel.

Click the Next button. (Which shouldn't be possible but now it is.)

6. The next page is displayed, namely "Review the SQL Script to be Executed."

(Again, it should not have been possible to get here having entered an incorrect password.)

Click the Next button.

7. Once again a pop-up window appears asking for your password -- albeit at the wrong page (step) and time.

This time enter the correct password, and you're good to go.

Suggested fix:
Don't continue to the next step upon entering an incorrect password.
[25 Apr 2017 9:25] Chiranjeevi Battula
Hello  Scavok,

Thank you for the bug report.
Verified this behavior on MySQL Workbench in 6.3.9 version

Thanks,
Chiranjeevi.
[31 May 2019 18:23] Christine Cole
Posted by developer:
 
Fixed as of the upcoming MySQL Workbench 8.0.17 release, and here's the changelog entry:

An incorrect password did not disable the Next button during the
forward-engineering of a valid model, but then the next step generated an
access-denied error while permitting the next action to continue after the
error. Now, a valid password is required before the next step in the
operation is available to select.

Thank you for the bug report.