Bug #56302 MySQLWorkBench prompting me for password when I didn't ask to connect
Submitted: 26 Aug 2010 17:33 Modified: 30 Nov 2010 11:35
Reporter: Kumi Hagimoto Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S3 (Non-critical)
Version:5.2.21RC Rev 5918, 5.2.28 OS:MacOS (10.6.4)
Assigned to: Alfredo Kojima CPU Architecture:Any
Tags: connecting, ssh

[26 Aug 2010 17:33] Kumi Hagimoto
Description:
I connected to remote MySQL database (TCP/IP over SSH) via  MySQLWorkBench, finished my work and closed the tab for the particular connection but left the MySQLWorkBench open as I had local dev MySQL connection that I was still using.  I left it like that overnight with laptop "asleep".  When I "woke up" the laptop, after a while, MySQLWorkbench automatically tried to connect to the remote DB and popped up a window asking me to type a password for the remote db.  Had I stored the password, it would have gone ahead and connected and opened up a tab for the remote db (I'm assuming).  If I wasn't paying attention, I could have done something that I shouldn't on the db thinking it was my local dev connecton.  More than anything, it was kind of alarming that it tried to connect on its own without me initiating a connection.

How to repeat:
Please see my description.
[26 Aug 2010 17:50] Johannes Taxacher
please try with most recent version of Workbench (5.2.26) if the problem is still appearing.
thanks in advance
[26 Sep 2010 19:19] Kumi Hagimoto
I got the latest version (5.2.28 Rev 6725) and it is still happening.  Same procedure to reproduce as noted in my initial post.  Thanks very much.
[12 Nov 2010 22:38] Alfredo Kojima
Did this happen with SQL Editor or Administration?
[13 Nov 2010 1:07] Kumi Hagimoto
I had SQL_Editor tabs (multiple) open connected to remote databases.  I hadn't done any administration during that particular session.  It doesn't have to be a remote database to cause this error.  It also happens when I'm connected to the local db on my laptop.
[20 Nov 2010 0:13] Alfredo Kojima
I haven't been able to repeat the bug exactly as described, but I can see that connections are still open after the editor tab is closed.
[26 Nov 2010 16:45] Johannes Taxacher
possible fix confirmed in repository. as i am also not able to reproduce the problem i'll set it to fixed - please try once next release is available and reopen if the problem still appears.
[30 Nov 2010 11:35] Tony Bedford
An entry has been added to the 5.2.31 changelog:

MySQL Workbench attempted to reconnect to a connection that had previously been closed in the SQL Editor, after the computer woke from the sleep state.