title: Cannot connect to database server, access denied to user root@%
body: <p>I'm receiving this error when trying to open my database connection:
  &quot;Cannot connect to database server
  your connection failed for user root@% to database [mydatabase]
  Please:</p>
  <ol>
  <li>check mysql is running on localhost</li>
  <li>check mysql is reachable on 3306</li>
  <li>check root has rights to connect to localhost</li>
  <li>Make sure youre both providing a password if needed&quot;</li>
  </ol>
  <p>I'm working on Mysql workbench on a windows 10 machine. I think my root privileges have been dropped (not sure how) so any advice on that also would be fab... thanks :)</p>