Solved

Using MySQL Workbench to Connect to Remote Server

Posted on 2010-08-19
6
2,935 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
  • 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
Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

 
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

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

Suggested Solutions

Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
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…

839 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