MySQL Bugs: #83855: Saved connection passwords not being reused when opening a connection

Bug #83855	Saved connection passwords not being reused when opening a connection
Submitted:	17 Nov 2016 1:00	Modified:	1 May 2017 20:15
Reporter:	Javier Treviño	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL for Windows: MySQL for Excel	Severity:	S2 (Serious)
Version:	1.3.6	OS:	Any
Assigned to:		CPU Architecture:	Any

Description:
When a connection is opened in MySQL for Excel, the password dialog is shown to users asking for the connection password.
There is an option to save the password in a secure password's vault (the one used by MySQL Workbench), so that the next time the connection is opened there is no prompt for the password.
In version 1.3.6 it seems passwords are not being loaded from the password's vault (or not being stored at all), since the password dialog is shown even when the option to save the password was used.

This was tested with MySQL Workbench installed, not sure if this happens as well when MySQL Workbench is not installed.

How to repeat:
1. Open Excel and enable MySQL for Excel.
2. Create a new connection to a MySQL server where the password is NOT specified.
3. Open the connection by double-clicking its icon.
4. The Password Dialog will be displayed, enter the password and check "Store password securely".
5. Go back to the Welcome Panel, and open the connection again.
6. The Password Dialog is displayed again, this is wrong and it should not appear.

Posted by developer:
 
Revised steps to duplicate:

Prerequisites:
1. Make sure MySQL Workbench is NOT installed and the "%APPDATA%\MySQL\Workbench" folder does not exist.
2. Make sure the "%APPDATA%\Oracle\MySQL for Excel" folder does not exist.
3. Make sure you have locally at least 1 MySQL Server installed as a Windows service.

How to repeat:
1. Open Excel and enable MySQL for Excel. You should see automatically created connections to the local MySQL Server instances. Do NOT open any connection.
2. Close Excel.
3. Install MySQL Workbench.
4. Open Excel and enable MySQL for Excel.
5. THIS STEP IS CRITICAL: You should get a dialog asking if you want to migrate local connections to the MySQL Workbench's connections file. Select from the drop-down at the lower-left corner "Delay Indefinitely" and click on "No". This means connections will remain on the "%APPDATA%\Oracle\MySQL for Excel" folder until migrated manually.
6. Create a new connection to a MySQL server where the password is NOT specified.
7. Open the connection by double-clicking its icon.
8. The Password Dialog will be displayed, enter the password and check "Store password securely".
9. Close Excel.
10. Open Excel and enable MySQL for Excel.
11. Double-click the connection created on step 6.
12. The Password Dialog is displayed again, this is wrong and it should not appear since the password was supposed to be already stored.

Posted by developer:
 
Fixed the case where passwords were not being stored in the MySQL for Excel's user data folder after MySQL connections were set to be migrated manually (the option to delay indefinitely was chosen) to the MySQL Workbench's connections file.

Posted by developer:
 
Fixed on build 2

Posted by developer:
 
Fixed as of the upcoming MySQL for Excel 1.3.7 release, and here's the changelog entry:

MySQL connection passwords were not saved to the secure password vault and
produced a password request every time an existing connection was opened.

Thank you for the bug report.