Link to home
Start Free TrialLog in
Avatar of chinniatluri
chinniatluriFlag for Afghanistan

asked on

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
Avatar of IanTh
IanTh
Flag of United Kingdom of Great Britain and Northern Ireland image

sounds like your network is not working netstat should not say 0.0.0.0

what does ipconfig /all say?
Avatar of chinniatluri

ASKER

Mysql is on Linux Server & I'm connecting from Wndows host.
yes so can your windows host ping the mysql linux sever?
ASKER CERTIFIED SOLUTION
Avatar of chinniatluri
chinniatluri
Flag of Afghanistan image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I didnt get sufficient input for looking into the issue from firewall end