asked on

Using MySQL Workbench to Connect to Remote Server

Hi Experts,

I currently have a this setup...

- Development PC on Windows XP
- Staging Server running Apachi on Ubuntu and Plesk MySQL v
- Production server running Apachi on Ubuntu and Plesk

Neither the staging or production servers are located on my dev pc- with this said, the staging server is located on our companies local network.

My problem is this: I need to connect to both servers using MySQL Workbench and all I can find for a Hostname on both servers are local addresses.

What is the best way to configure and connect to these database servers?

Many thanks for your help

wilson100

wilson1000

ASKER

Hi,

I've managed to connect to the Production server:

The current issue is connecting to our staging server - is there away to resolve the IP address of the database on localhost?

Many thanks

theGhost_k8

I think you just need to have hostname/ip and access credentials to remote mysql server.
Using "New Connection" link you can open "Set up New Connection" Wizard and rest upi need to follow the ui.

Online Doc:http://dev.mysql.com/doc/workbench/en/index.html
Download: http://dev.mysql.com/doc/index-gui.html

ASKER CERTIFIED SOLUTION

theGhost_k8

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

wilson1000

ASKER

Thank you!

Did a ping and got the IP :o)

What I have now is an 'in-hospitable' server. It's not allowing connections so I assume RDP is disabled on the LAN machine.

Can you tell me what the security ramifications might be if I was to allow RDP?

theGhost_k8

I'm not sure about how u have concluded for RDP. But if your mysql is not connecting then its possible that it is a priviledge issue. May be your username/pwd is not granted to connect from a remote host!!???

wilson1000

ASKER

OK, yeah I see you point here. I'll have to wait until our backend developer can take a look at that.

Thank again for your help here!