Menu
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?
965
You can set up multiple instances of mysql but for your situation you are better off creating different databases within the same instance. You can create databases and then add users that only have access to manipulate the database they are given and nothing else.
To view the database created on MySQL Workbench, navigate to Database > Connect to Database . Choose an existing connection to connect to MySQL Server or create a new one. The database created will be as shown in the screenshot below.
To open Schema Inspector click (i) icon that shows up on hover over schema name: or right click schema and select Schema Inspector. When Schema Inspector opens go to Columns tab. All columns are visible in a grid.
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):
111
To launch multiple instances of WorkBench thru the Mac Terminal
Mac Version: OS X El Capitan Version 10.11.6
Workbench Version: Version 6.2.5.0. Build 397 (32bit) ###
On Your Mac;
MySQLWorkbench Terminal ps ax | grep -i workbench (as stated above by Derek) /Applications/MySQLWorkbench.app/Contents/MacOS/MySQLWorkbench Instances on your mac
open -Fna /Applications/MySQLWorkbench.app/Contents/MacOS/MySQLWorkbench
Further Explanation: (from the man pages for open)
-F Opens the application "fresh," that is, without restoring windows. Saved persistent state is lost, except for Untitled documents.-n Open a new instance of the application(s) even if one is already running.-a application Specifies the application to use for opening the file
37
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
