• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1889
  • Last Modified:

Unable to connect to any of the specified MySQL hosts.

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1

# Disabling symbolic-links is recommended to prevent assorted security risks;
# to do so, uncomment this line:
# symbolic-links=0

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid


Unable to connect to any of the specified MySQL hosts.when trying to connect to remote mysql server using Toad for Mysql.

I was able to connect successfully previously & I lost it today.

Below is result of netstat                                  
                                                                           
tcp        0      0 0.0.0.0:3306                0.0.0.0:*                LISTEN
0
chinniatluri
Asked:
chinniatluri
  • 3
  • 2
1 Solution
 
IanThCommented:
sounds like your network is not working netstat should not say 0.0.0.0

what does ipconfig /all say?
0
 
chinniatluriAuthor Commented:
Mysql is on Linux Server & I'm connecting from Wndows host.
0
 
IanThCommented:
yes so can your windows host ping the mysql linux sever?
0
 
chinniatluriAuthor Commented:
Issue is with FIrewall IPtables...Modifying it resolved the issue
0
 
chinniatluriAuthor Commented:
I didnt get sufficient input for looking into the issue from firewall end
0

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now