My solution is to create as many aliases as schemes you need to access, each for one schema.  Then I can run cross-schema queries by specifying alias (I actually use it for Sybase, but it should work for MySQL as well).
Alexandre Peshansky, MS
Senior Bioinformatics Analyst, Research Informatics Core (RIC)
Einstein-Montefiore Institute for Clinical and Translational Research (ICTR)
Albert Einstein College of Medicine
1300 Morris Park Ave, Mazer Bldg., Rm 534 Bronx, NY 10461
(718) 430-2440 (Mo, We, Fr)  (718) 920-4885 (Tu & Th)

From: Oleg Poleshuk []
Sent: Wednesday, January 23, 2013 11:31 AM
Subject: [Squirrel-sql-users] MySql Schema load


I'm using SQuirreL SQL 3.4.0 to access my local MySql database.
Connection is opened fine, but I have to manually specify active Schema if I want to see it's tables.
It makes impossible to write requests for multiple schemas as SQuirreL SQL doesn't recognize tables from non-current schema.

Alias properties -> Schemas is set to Load all and cache all Schemas. If I set it to Specify schema loading and caching and click on "Connect database to refresh Schema table" nothing happens. I enabled debug logging but couldn't find anything useful in a log file.
I'm using latest Mysql Connector 5.1.22.

Thanks in advance for your help!