MySQL Administrator remembering the password 1

[LittleSmudge]

I have MySQL installed on a Windoz2000 platform and I'm using MySQL Administrator to manage the thing.

Until recently MySQL Administrator would remember the StoredConnection, ServerHost and UserName but the Password box was always blank and needed me to enter the password each time I started it up.
This was fine.

However it now remembers the password as well ! & this is NOT good.


I can find no way of getting rid of the password from the dialog box or telling MySQL Administrator not to remember it.

There must be a setting somewhere that I've inadvertently flipped - but I can't find it.

Any ideas ?




G LS
spsinkNOJUNK@yahoo.co.uk
Remove the NOJUNK to use.

 

[TonyGroves]

I've never come across that problem and I can't see why it would happen, but presumably the program is storing your password in its config file, which appears to be MySQL\mysqlx_user_connections.xml , in your Application Data directory. You could edit that file to remove the password, and see if that works. If it persists in saving the password, you could write a little shell script which would call the program and when it's finished, overwrite the options file with a password-less one.

 

[rzs0502]

Open MySQL Administrator
On the logon screen, click the Square button on the Stored Connection field to open the Connection Manager.
Click on the General options on the left pane and deselect the Store Passwords option box on the right.


"If you always do what you've always done, you will always be where you've always been."

 

[LittleSmudge]

Thanks rzs0502

I can't remember setting that up - but your instruction has certainly solved the problem.



G LS
spsinkNOJUNK@yahoo.co.uk
Remove the NOJUNK to use.

 

[LittleSmudge]

Well I thought that had worked.

After some investigation - it now seems that the password is not remembered when I delete it from the Stored Connection .. ..

but then after then next successful log in it goes BACK into the stored connection and thus returns to be preloaded into the Password box on the next log in attempt.


Arrrgh !




G LS
spsinkNOJUNK@yahoo.co.uk
Remove the NOJUNK to use.