title: MySQL Workbench: "Can't connect to MySQL server on 127.0.0.1' (10061)" error
body: <p>I apologise.. I know this question has been asked many times before, but I've tried lots of suggestions, and simply can't find a solution.</p>
  
  <p>The problem:  I have a MySQL database running on a hosted server.
  I have to use SSH to connect to it, and I have the relevant Public and Private Key files.</p>
  
  <p>I specifically want to use the PC version of <em>MySQL Workbench</em>, to access this database, for running queries, checking data, etc.</p>
  
  <p>If I run <strong>Sequel Pro</strong> on a Mac, it connects fine, and I can browse and query the database.  No problems.</p>
  
  <p>If I run the trial version of <strong>SQLyog</strong> on a PC, it also connects fine.  No problems.</p>
  
  <p>But if I try to connect use MySQL's own "<strong>MySQL Workbench</strong>" application, using exactly the same settings and SSH Private Key file, it refuses to connect, throwing the well-known error:</p>
  
  <p><strong>Can't connect to MySQL server on 127.0.0.1' (10061)</strong></p>
  
  <p>I find it frustrating, as, in SQL Workbench, I specified the "MySQL Hostname" to use, <em>db01.mysql.vm.MyHostingServer.net</em>, but Workbench seems to ignore it, and demand to connect to 127.0.0.1 instead.</p>
  
  <p>(I have read that Workbench says it needs the Public key file, but actually means the Private key file... and I have tried with both.  I've also tried with <em>MySQL Workbench</em> on a Mac, but that crashed all over the place, simply when I was typing in server names and passwords..  it was a mess !!)</p>
  
  <p>The hosting service I've gone with gives me limited permissions for changing MySQL settings, and given that Sequel Pro and SQLyog <em>can</em> connect successfully, I don't want to start messing about and changing things randomly.</p>
  
  <p>Any ideas...?</p>