Connect to two DB same server...

[Enrique Welch]

Hello,

I have an application that uses two databases in the same server that need to share data.

Is important to have diferent users/password for each DB but i need to cross data between both. This is an example:

DB1: Table "A" user "aaaa"
DB2: Table "B" user "bbbb"

SELECT * FROM A INNER JOIN B ON x=x

I know this can be done using the same user and password but I need to know if is possible using diferent user.

I am using in my perl application DBI / DBD mysql... if is possible... how can i do connections?

Thanks in advance



Edited 1 time(s). Last edit at 03/23/2012 11:21AM by Enrique Welch.