Is there a way to export my existing connections f

问题:

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.

Thanks in advance.

回答1:

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

回答2:

You can import a plist file using Sequel Pro. Click the gear icon in the bottom left.

credit to james-chevalier for showing me how to do this.

回答3:

1. Open Keychain Access using Alfred.
2. Find (top right of GUI): sequel
3. Double-click the result you're looking for... It should be something like root@localhost/
4. Checkbox Show Password
5. Type in your Mac password
6. Enjoy