Description:
I have 5 machines and I want them all to share the same connections.xml. Furthermore I want any user to be able to modify a connection and have it propagate everywhere.
I am trying to achieve this by keeping connections.xml on a central server and replacing the client connections.xml with a symbolic link that points to the copy on the server.
When Workbench modifies connections.xml, it does so by deleting it and then generating a new connections.xml.
If a symbolic link is in the Workbench folder, it gets deleted and replaced by a file, and therefore the link is broken.
I am guessing this applies to all MySQL settings files, not just connections.xml.
Furthermore this affects any permissions set on connections.xml.
Thank you for reading.
How to repeat:
1. Move connections.xml to [A]
2. Use mklink to create a symbolic link to connections.xml, e.g. "mklink connections.xml [A]"
3. Open workbench (verify settings are loading correctly)
4. Edit a connection
5. Close workbench
6. Check the connections.xml symbolic link, it is now replaced by a file
(I find this works even if you don't edit a connection)
Suggested fix:
Have Workbench edit its settings files, rather than deleting them and creating new ones.
This is the policy used by other software such as WinSCP and FileZilla.