Solved

Using MySQL Workbench to Connect to Remote Server

Posted on 2010-08-19
6
2,971 Views
Last Modified: 2013-11-21
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
Comment
Question by:wilson1000
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
6 Comments
 
LVL 4

Author Comment

by:wilson1000
ID: 33473568
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
 
LVL 21

Expert Comment

by:theGhost_k8
ID: 33473594
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
 
LVL 21

Accepted Solution

by:
theGhost_k8 earned 500 total points
ID: 33473597
you may ping staging server's url
0
Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

 
LVL 4

Author Comment

by:wilson1000
ID: 33474039
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
 
LVL 21

Expert Comment

by:theGhost_k8
ID: 33474225
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
 
LVL 4

Author Comment

by:wilson1000
ID: 33474695
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

Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Background Information Recently I have fixed file server permission issues for one of my client. The client has 1800 users and one Windows Server 2008 R2 domain joined file server with 12 TB of data, 250+ shared folders and the folder structure i…
In this series, we will discuss common questions received as a database Solutions Engineer at Percona. In this role, we speak with a wide array of MySQL and MongoDB users responsible for both extremely large and complex environments to smaller singl…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question