mysql-workbenchsequelpro

Is there a way to export my existing connections from MySQL Workbench to Sequel PRO

Is there a way to export my existing connections from MySQL Workbench to Sequel PRO

I have been browsing through all options I could and I cant find an option that would let me export all my connections from workbench

I have a lot of connections in the workbench and I am planning on using sequel pro now.

Solution

  • Unfortunately due to the fact that Sequel Pro does not have option to import connections at all, you will be unable to import the connections.

    There are two ways in order to export your connections from MySQL Workbench into a file:

    1. Follow the procedure to export the connections from the menu:

      Open and Select MySQL Workbench > In the Menu bar select Tools > Configuration > Backup Connections

    2. Find the CONNECTIONS.XML file located at

      Users/Username/Library/Application Support/MySQL/Workbench/connections.xml

    About Sequel Pro...

    1. The connections strings are stored in the following preference file:

      ~/Library/Preferences/com.sequelpro.SequelPro.plist

    2. The passwords are stored in the Mac OSX Keychain, which is stored here:

      ~/Library/Keychains/login.keychain