LinuxQuestions.org
Welcome to the most active Linux Forum on the web.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices

Reply
 
LinkBack Search this Thread
Old 10-18-2013, 01:47 PM   #16
rjo98
Senior Member
 
Registered: Jun 2009
Location: US
Distribution: RHEL, CentOS
Posts: 1,328

Original Poster
Rep: Reputation: 36

Thanks. I will need it haha
 
Old 10-19-2013, 12:53 PM   #17
Doug G
Member
 
Registered: Jul 2013
Posts: 56

Rep: Reputation: Disabled
Just a note, for any remote mysql management tool to work you'll have to make sure mysql itself allows access from your remote client computer, and that the firewall and any routhers on the mysql server allows mysql connections.
 
1 members found this post helpful.
Old 10-21-2013, 03:24 AM   #18
TenTenths
Senior Member
 
Registered: Aug 2011
Location: Dublin
Distribution: Centos 5 / 6
Posts: 1,251

Rep: Reputation: 395Reputation: 395Reputation: 395Reputation: 395
Quote:
Originally Posted by Doug G View Post
Just a note, for any remote mysql management tool to work you'll have to make sure mysql itself allows access from your remote client computer, and that the firewall and any routhers on the mysql server allows mysql connections.
Good advice.

Personally I use Navicat on my windows desktop to administer a number of MySQL servers, some on the local subnet and most in data centers.

Navicat allows a connection to be defined to create an SSH tunnel from the Windows desktop to the remote server, thus using the "localhost" configuration for access, also means not having to open external access unless it's absolutely necessary.
 
1 members found this post helpful.
Old 10-21-2013, 04:57 AM   #19
zhjim
Senior Member
 
Registered: Oct 2004
Distribution: Debian Squeeze x86_64
Posts: 1,435
Blog Entries: 11

Rep: Reputation: 181Reputation: 181
From security perspective I'd always go with a ssh tunnel like TenTenth brought up. Workbench also has this natively. This approach also makes it easier on the firewall side as well as mysql server. No real need for any extra holes. SSH is normaly allowed by iptables. Local connection to mysqld as well. So a tunnels is the easiest and much secure approach I'd say.

phpMyAdmin can be run from anywhere (where a httpd server is installed) it just needs a connection to the mysql server. Not sure if it supports ssh tunnel meanwhile but one can always set one up manually or per script. The down side is if you don't own it you can not connect to every mysql server. You'd have to configure it. Also there might be an option where you just put in credentials and server and hit and go but I bet that those infos are not preserved for later use.
If you use it definitely use some auth mechanism on the webserver to block unwanted pokers.
 
1 members found this post helpful.
Old 10-21-2013, 02:25 PM   #20
rjo98
Senior Member
 
Registered: Jun 2009
Location: US
Distribution: RHEL, CentOS
Posts: 1,328

Original Poster
Rep: Reputation: 36
Thanks guys. I'll take a look at navicat too.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
remotely installing rhel server 6 remotely jwenzel09 Red Hat 2 10-24-2011 08:22 AM
Can we install RHEL 5.3 remotely ? agent_mach Linux - Newbie 2 12-31-2010 12:08 AM
LXer: Administer servers remotely with Web Console LXer Syndicated Linux News 0 05-02-2008 12:50 PM
Log in to mysql remotely chamalsl Linux - Security 6 03-23-2005 01:40 PM
How to remotely administer RedHat 7.2 using Windows 2000 Daemen Linux - Newbie 2 06-04-2004 02:41 PM


All times are GMT -5. The time now is 05:41 AM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration