[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3065
  • Last Modified:

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 server details from plesk
0
wilson1000
Asked:
wilson1000
  • 3
  • 3
1 Solution
 
wilson1000Author Commented:
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
0
 
K VDatabase ConsultantCommented:
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
0
 
K VDatabase ConsultantCommented:
you may ping staging server's url
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
wilson1000Author Commented:
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?
0
 
K VDatabase ConsultantCommented:
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!!???
0
 
wilson1000Author Commented:
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!

0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now