Can't connect to MySQL server on '192.168.0.4' (10061)

[DataRater]

I have MySQL ver 14.12 installed on a Dell Inspiron Ubuntu laptop and i am trying to access MySQL from my Windows laptop which are all on my home network.

 

To do the access i am using SQLyog version v6.56. I have the connect set to

192.168.0.4

stephen

<password>

3306

no databases selected s:qq:q

o expect access to all.

 

When I query the mysql.user table I get

mysql> select host, user from user;

+--------------+------------------+

| host        | user            |

+--------------+------------------+

| %            | stephen          |

| 127.0.0.1    | root            |

| dell-desktop | root            |

| localhost    | debian-sys-maint |

| localhost    | root            |

+--------------+------------------+

5 rows in set (0.00 sec)

 

I suspect MySQL is not listening on port 3306 but don't know how to prove it.

 

Please help.

 

Steve

[DataRater]

Sorry the title say 169 and it is in fact 168.

 

I've edit the error above so this post isn't required but i don't know how to delete it.

[DataRater]

In my.cnf there is a line which says

 

# Instead of skip-networking the default is now to listen only on

# localhost which is more compatible and is not less secure.

bind-address = 127.0.0.1

 

and I need this to also point at my Windows laptop on 192.168.0.2

 

Have you any idea how to do that? Do I need both IP addreses or just one?

[DataRater]

So commenting out

bind-address = 127.0.0.1

like

#bind-address = 127.0.0.1

 

means it now works.

 

I'm not sure that this is the best way to make it work.

 

Any thoughts gurus?

 

[fenway]

Sometime localhost and 127.0.0.1 on windows aren't the same.