Solved

Unable to connect remotely to my mysql server on a linux system

Posted on 2010-11-24
5
487 Views
Last Modified: 2012-05-10
From my linux system, it shows mysql is up and running from the output of the following command:

[root@localhost ~]# netstat -npl | grep tcp
tcp        0      0 0.0.0.0:3306                0.0.0.0:*                   LISTEN      31579/mysqld        
tcp        0      0 0.0.0.0:111                 0.0.0.0:*                   LISTEN      3294/portmap        
tcp        0      0 127.0.0.1:631               0.0.0.0:*                   LISTEN      2884/cupsd          
tcp        0      0 127.0.0.1:25                0.0.0.0:*                   LISTEN      3534/sendmail: acce
tcp        0      0 0.0.0.0:953                 0.0.0.0:*                   LISTEN      3315/rpc.statd      
tcp        0      0 :::80                       :::*                        LISTEN      3580/httpd          
tcp        0      0 :::22                       :::*                        LISTEN      3513/sshd          
tcp        0      0 :::443                      :::*                        LISTEN      3580/httpd          
[root@localhost ~]#


I can't seem to connect to  it remotely from a window system using MySQL Workbench application. What else can I try to do to get a connection?
0
Comment
Question by:areyouready344
  • 3
5 Comments
 
LVL 4

Expert Comment

by:max-hb
Comment Utility
Make sure your MySQl server is listening for incoming connections:

Follow instructions at http://www.cyberciti.biz/tips/how-do-i-enable-remote-access-to-mysql-database-server.html especially step 3!
0
 

Author Comment

by:areyouready344
Comment Utility
Thanks max-hb, how can i get the mysqld process to listen on the ip address of 192.168.1.137

cp        0      0 0.0.0.0:3306                0.0.0.0:*                   LISTEN      31579/mysqld  


0
 
LVL 14

Expert Comment

by:DonConsolio
Comment Utility
Your mysqld is already listening on ALL interfaces (0.0.0.0), but on the quite unusual port 31579

to get a listening server for  192.168.1.137 on dthe default port of 3306 use:

[mysqld]
...
port            = 3306
bind-address    = 192.168.1.137
...

and restart your mysql server. You may also want to verify you have no firewall active.
0
 

Accepted Solution

by:
areyouready344 earned 0 total points
Comment Utility
Working, thanks to this document located at:

http://benrobb.com/2007/01/15/howto-remote-root-access-to-mysql/
0
 

Author Closing Comment

by:areyouready344
Comment Utility
worked great
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Join & Write a Comment

Foreword In the years since this article was written, numerous hacking attacks have targeted password-protected web sites.  The storage of client passwords has become a subject of much discussion, some of it useful and some of it misguided.  Of cou…
I have been using r1soft Continuous Data Protection (http://www.r1soft.com/linux-cdp/) for many years now with the mySQL Addon and wanted to share a trick I have used several times. For those of us that don't have the luxury of using all transact…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…

744 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

17 Experts available now in Live!

Get 1:1 Help Now