Solved

Open port 3306 on Solaris for MySQL

Posted on 2011-03-15
6
1,093 Views
Last Modified: 2012-05-11
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.
0
Comment
Question by:Alan Taylor
  • 3
  • 3
6 Comments
 
LVL 12

Expert Comment

by:upanwar
ID: 35136491
show us.

netstat -an | grep 3306

or If you have lsof then show us.

# lsof -i |grep :3306
0
 

Author Comment

by:Alan Taylor
ID: 35136698
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.
0
 
LVL 12

Expert Comment

by:upanwar
ID: 35136752
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
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

Author Comment

by:Alan Taylor
ID: 35150688
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?
0
 
LVL 12

Accepted Solution

by:
upanwar earned 500 total points
ID: 35153505
It seems that now your server is listening on network interface so Its getting the connection but have you grant the permission to your dalabase to connect remotly.

I would suggest the GUI tool to connect mysql database remotly and query your database. You may aware some GUI tool and I have also found for you.

Install one of these tool on your windows box, connect your database and query.

http://dev.mysql.com/downloads/workbench/

http://www.databasejournal.com/features/mysql/article.php/3880961/Top-10-MySQL-GUI-Tools.htm
0
 

Author Closing Comment

by:Alan Taylor
ID: 35885400
After installing as per the solution a secondary file was found which required amendment.
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Access_log 17 95
SQL inner join confusion 15 42
Which is more secure: EAP or machine certificate for IKEv2 VPN? 1 32
PHP: concatenate query 12 28
It’s 2016. Password authentication should be dead — or at least close to dying. But, unfortunately, it has not traversed Quagga stage yet. Using password authentication is like laundering hotel guest linens with a washboard — it’s Passé.
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

947 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now