If it says Cannot Connect to Local Host (the server controls or sqlyog, navicat anything. this works for it). Go to Start Menu-->Run-->Type in "CMD" (without the ")--> then type "Ping 127.0.0.1" (without the ") let it do what it has to do--> then type "tracert 127.0.0.1" (without the ") let it do what it has to do--> then your complete go a head connect to what ever it wouldn't let you connect to.
This is maybe common knowledge...
________________________________________________________________