The connection worked fine the other day and for some reason is doesn't. MySQL is running in Ubuntu Server 12.04 and I am trying to connect to a database using ODBC Connector 5.1 from Windows 7.

I have tried commenting out and keeping the bind-address in the cnf file. I have tried to grant all access. I have been reading endless amounts of tutorials and posting to attempt to figure it out. I cannot figure out what is going on, also I am a newbie to all this and I have noticed that most posting leave out some minor things that others may be attuned to.

Help! Thanks in advance.

The service is running and I get the following from netstat -tlpen | grep mysql:

tcp  0  0.0.0.0.0:3306  0.0.0.0:*  LISTEN  106  15172  3565/mysqld

I get the following from netstat -tlpen:

    Active Internet connections (only servers)

Proto Recv-Q Send-Q Local Address           Foreign Address         State       User       Inode       PID/Program name

tcp        0      0 0.0.0.0:3306            0.0.0.0:*               LISTEN      106        15172       3565/mysqld     

tcp        0      0 0.0.0.0:139             0.0.0.0:*               LISTEN      0          7092        776/smbd        

tcp        0      0 0.0.0.0:111             0.0.0.0:*               LISTEN      0          8325        784/rpcbind     

tcp        0      0 0.0.0.0:10000           0.0.0.0:*               LISTEN      0          9759        1325/perl       

tcp        0      0 0.0.0.0:44819           0.0.0.0:*               LISTEN      0          9584        -               

tcp        0      0 0.0.0.0:22              0.0.0.0:*               LISTEN      0          8809        947/sshd        

tcp        0      0 0.0.0.0:445             0.0.0.0:*               LISTEN      0          7090        776/smbd        

tcp        0      0 0.0.0.0:2049            0.0.0.0:*               LISTEN      0          9000        -               

tcp6       0      0 :::139                  :::*                    LISTEN      0          7088        776/smbd        

tcp6       0      0 :::111                  :::*                    LISTEN      0          8328        784/rpcbind     

tcp6       0      0 :::22                   :::*                    LISTEN      0          8811        947/sshd        

tcp6       0      0 :::445                  :::*                    LISTEN      0          7085        776/smbd        

tcp6       0      0 :::2049                 :::*                    LISTEN      0          9003        -               

tcp6       0      0 :::47906                :::*                    LISTEN      0          9586        -     

iptable -L

Chain INPUT (policy ACCEPT)

target     prot opt source               destination         



Chain FORWARD (policy ACCEPT)

target     prot opt source               destination         



Chain OUTPUT (policy ACCEPT)

target     prot opt source               destination