MySQL 2003 Error : can't connect to localhost (10061), but PHPMyAdmin works

Question

I'm trying to connect to the MySQL server that came with WAMPServer locally using SQLYog, but it gives me this error:

Error No. 2003

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

However, phpmyadmin works just fine, and mysql_connect() works fine with the WAMP's default login details:

hostname: localhost

username: root

password: empty

The server's on, why can't I connect to localhost on SQLYog with root, when phpmyadmin works fine?

Happens with HeidiSQL too. Does anyone have an idea? Thanks.

Answer 1

I had the same issue in HeidiSQL, turned out my plink timeout was too low. As soon as I increased the timeout, my problem was solved!

Answer 2

You must use plink connect the mysql host if that is never connected firstly plink -v -L 10085:host:3306 user@host

And then config HeidiSQL normally