Alan Taylor
asked on
Open port 3306 on Solaris for MySQL
I have a Solaris 10 Virtaul Server running under VMWare. The system has MySQL installed on it and runs fine. However when we try to connect on Port 3306 it refuses connection, there is no firewalling in place on the machine attempting connection and the Solaris system is not firewalled at all, yet still we cannot complete this ODBC connection on Port 3306. We can ping the machine and telnet to port 23 with no issue.
ASKER
Thanks for the quick response upanwar.....please see below for result of netstat command:
127.0.0.1.3306 *.* 0 0 49152 0 Listen
Thanks again for your help.
127.0.0.1.3306 *.* 0 0 49152 0 Listen
Thanks again for your help.
As per the given output mysql is listening on Localhost, that is the reason you are not able to connect it from remote machine.
Please follow this to enable remote connection to your mysql server.
http://www.cyberciti.biz/tips/how-do-i-enable-remote-access-to-mysql-database-server.html
Please follow this to enable remote connection to your mysql server.
http://www.cyberciti.biz/tips/how-do-i-enable-remote-access-to-mysql-database-server.html
ASKER
Thanks for the response upanwar, I took a good look at this and have made some limited progress. I would be grateful if you have any further advice regarding the points I have raised below.
Thanks again
Alan
The port has been changed (now 32782) and you can now telnet over to the solaris box.
When running the ODBC driver, ‘snoop’ shows the connection being made.
But nothing is then fed back as though the Solaris box is not looking for / picking up this connection?
Are there any services that should be running to pick this connection up and if so how can we test them?
Thanks again
Alan
The port has been changed (now 32782) and you can now telnet over to the solaris box.
When running the ODBC driver, ‘snoop’ shows the connection being made.
But nothing is then fed back as though the Solaris box is not looking for / picking up this connection?
Are there any services that should be running to pick this connection up and if so how can we test them?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
After installing as per the solution a secondary file was found which required amendment.
netstat -an | grep 3306
or If you have lsof then show us.
# lsof -i |grep :3306