How to create DB link in MySQL
Posted by: Santosh Walavalkar
Date: September 12, 2020 09:08AM

Hi Forum team,

I have a requirement where I need to create POC for DB link between two separate MySQL servers. I have installed MySQL server 5.5.0-m2 on my laptop (Windows 7 Enterprise, 64 Bit).

Now I have below queries and need help.

1. Can I install/configure another instance of 5.5.0-m2 of MySQL DB on the same laptop?

2. If yes, then how and where can/should install/configure it on laptop (different drive?) is already having same version.

3. If I cannot have another instance of the 5.5.0-m2 MySQL DB server on the same laptop, can I install/configure another DB server of different version?

4. If answer to 3 is yes, then which version should it be, higher version or lower version of 5.5.0-m2?

5. How to create a DB link between two different servers on the same laptop?
How to fetch/join data between tables created on separate DB servers?

Regards
Santosh

Options: ReplyQuote


Subject
Views
Written By
Posted
How to create DB link in MySQL
245
September 12, 2020 09:08AM
78
September 12, 2020 09:32AM
83
September 12, 2020 03:57PM
29
February 22, 2021 08:31AM


Sorry, only registered users may post in this forum.

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.