Linux - SoftwareThis 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.
Welcome to LinuxQuestions.org, a friendly and active Linux Community.
You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today!
Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.
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.
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.
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.