MySQL does not work on localhost without Local Area Connection
Posted
by
user985171
on Stack Overflow
See other posts from Stack Overflow
or by user985171
Published on 2012-09-13T14:03:35Z
Indexed on
2012/09/13
15:38 UTC
Read the original article
Hit count: 224
I use WampServer(Apache, PHP, MySQL) and have no problems when some kind of network adapter(wireless or lan) is connected(i-e Local Area Connection has status connected) 'even if i am not connected to the internet'(for example when i am connected to the router but that is not connected to the internet).
When there is no network connection, i get a php error like MySQL could not connect to 127.0.0.1 on port 3306.
Interestingly, 'telnet 127.0.0.1 3306' says that it could not connect to the port, even when the server and MySQL are running fine(i-e when some kind of local area connection is connected).
So i turned off all kinds of firewall(antivirus and windows) but still no difference in anything. And that is why this issue is quite puzzling.
Things i have already tried(will update this list along the way):-
-The skip-networking directive in my.ini.
© Stack Overflow or respective owner
