how to open multiple model/database in mysql workbench

mysql mysql-workbench
Developer Desk picture Developer Desk · Jan 20, 2014 · Viewed 20.2k times · Source

I have two model 

1) Server Model : conneted to remote database which is stored on server

2) Local Host :  connected to my pc database is stored in on pc.

I want to query to both database tables simultaneously. Each time i have to switch between database model.

How to do it?

Answer

Mike Lischke picture Mike Lischke · Jan 21, 2014

That's a traditional limitation of MySQL Workbench. You cannot open 2 models at the same time in a single instance of MySQL Workbench. On some platforms (like Windows) you can however open multiple instances (just be careful when changing settings, connections etc. as they are shared among all instances, last save wins).

On Windows you may have to enable multiple instances first by changing the setting under Edit > Preferences > Others (tab):

enter image description here

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