?
Solved

Using MySQL Workbench to Connect to Remote Server

Posted on 2010-08-19
6
Medium Priority
?
2,999 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:K V
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:
K V earned 2000 total points
ID: 33473597
you may ping staging server's url
0
Percona Live Europe 2017 | Sep 25 - 27, 2017

The Percona Live Open Source Database Conference Europe 2017 is the premier event for the diverse and active European open source database community, as well as businesses that develop and use open source database software.

 
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:K V
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

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

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

Recently, Microsoft released a best-practice guide for securing Active Directory. It's a whopping 300+ pages long. Those of us tasked with securing our company’s databases and systems would, ideally, have time to devote to learning the ins and outs…
Recently I was talking with Tim Sharp, one of my colleagues from our Technical Account Manager team about MongoDB’s scalability. While doing some quick training with some of the Percona team, Tim brought something to my attention...
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

770 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