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.

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.

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.