MySQL Forums
Forum List  »  Perl

Connect to two DB same server...
Posted by: Enrique Welch
Date: March 23, 2012 11:16AM

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.

Options: ReplyQuote


Subject
Written By
Posted
Connect to two DB same server...
March 23, 2012 11:16AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.