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

mysql-workbench sequelpro
Nick Div picture Nick Div · Aug 6, 2015 · Viewed 50.3k times · Source

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.

Answer

Anton Todorov picture Anton Todorov · Aug 6, 2015

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

Related questions

MySQL error code: 1175 during UPDATE in MySQL Workbench

I'm trying to update the column visited to give it the value 1. I use MySQL workbench, and I'm writing the statement in the SQL editor from inside the workbench. I'm writing the following command: UPDATE tablename SET columnname=1; It gives …

Read More
MySQL: How to allow remote connection to mysql

I have installed MySQL Community Edition 5.5 on my local machine and I want to allow remote connections so that I can connect from external source. How can I do that?

Read More
Access Denied for User 'root'@'localhost' (using password: YES) - No Privileges?

I am continuously receiving this error. I am using mySQL Workbench and from what I am finding is that root's schema privileges are null. There are no privileges at all. I am having troubles across platforms that my server is …

Read More