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.