LinuxQuestions.org
Review your favorite Linux distribution.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices



Reply
 
Search this Thread
Old 02-27-2007, 01:28 PM   #1
OpusMBE
LQ Newbie
 
Registered: Feb 2007
Posts: 2

Rep: Reputation: 0
remote connection to MySQL


Greetings. I am very new to both Linux and MySQL. I have "inherited" (translation...had dumped in my lap) a Sun Fire v240 running Solaris Version (your guess is as good as mine...I told you I was new at this). I am attempting to set up MySQL Admin to manage a database on the server. When I am actually on the server (through SSH) I can run MySQL and interact with the database with no problem. Through using "show variables" when on the mysql database, I can see that MySQL is using port 3306 and that "skip_networking" appears to be OFF. A Netstat -a verifies that port 3306 is "listening". I've had our ITS people hook me up with a static IP (that I've set up as my domain for attempting to make a remote connection), and remove all firewall blocks between that IP and the server where MySQL is running. Unfortunately, I still can't get the GUI interface to connect. Trying to telnet to the server port 3306 from my remote computer doesn't work (telnetting to localserver port 3306 while logged directly on to the server results in a bit of machine language then the message that the connection has been closed by a foreign host..is this normal?). I've also tried (unsuccessfully) to set up a tunnel through SSH. I would like to check the my.cnf file, but I can't seem to find it. At this point, I'm completely stuck, so any advice would be greately appreciated.

Thanks.
 
Old 02-27-2007, 01:38 PM   #2
derzok
Member
 
Registered: Aug 2004
Location: Ohio
Distribution: Debian, Slackware
Posts: 58

Rep: Reputation: 15
Your mysql server may not be configured to allow outside connections. Many times (for security reasons) the server will ONLY accept connections from localhost. http://help.hardhathosting.com/question.php/87 might help you out a bit. I'll dig up some more links.
 
Old 02-28-2007, 10:19 AM   #3
OpusMBE
LQ Newbie
 
Registered: Feb 2007
Posts: 2

Original Poster
Rep: Reputation: 0
problem solved!

The problem has been solved (though not by me). Another discussion with our firewall team revealed that they had my ip address wrong, and therefore the ports were still blocked between my computer and the mysql server. They have corrected that problem, and now I am able to get mysql admin to connect with no problems.
 
  


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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mysql remote connection issue Jukas Linux - Software 7 11-05-2011 11:25 PM
MySQL Remote Connection aquatux Linux - Server 5 12-26-2006 08:12 PM
Mysql Remote Connection Problems harbringer Linux - Software 5 04-14-2005 03:42 PM
Remote Mysql Connection in PHP ElementNine Programming 2 05-03-2004 05:24 PM
Remote Connection to mysql server Graanco Linux - General 1 07-19-2003 12:27 AM


All times are GMT -5. The time now is 10:20 PM.

Main Menu
Advertisement
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