Just to point out,

GRANT ALL ON *.* to fooUser@'<IP Address/Host name of the machine from where you are trying to access MYSQL Server' IDENTIFIED BY '<Password>';

essentially creates a user...

one way to do it could be to have a master report with 5 subreports each pulling a resultset. If you need to manipulate the resultset I don't know if...