Welcome to the most active Linux Forum on the web.
Go Back > Forums > Linux Forums > Linux - Software
User Name
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.


  Search this Thread
Old 02-27-2007, 12:28 PM   #1
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 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.

Old 02-27-2007, 12:38 PM   #2
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. might help you out a bit. I'll dig up some more links.
Old 02-28-2007, 09:19 AM   #3
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.


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 10:25 PM
MySQL Remote Connection aquatux Linux - Server 5 12-26-2006 07:12 PM
Mysql Remote Connection Problems harbringer Linux - Software 5 04-14-2005 02:42 PM
Remote Mysql Connection in PHP ElementNine Programming 2 05-03-2004 04:24 PM
Remote Connection to mysql server Graanco Linux - General 1 07-18-2003 11:27 PM > Forums > Linux Forums > Linux - Software

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

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