title: ERROR 1045 (28000): Access denied for user 'root'@'%'
body: <p>I am trying to run </p>
  
  <p><code>GRANT ALL PRIVILEGES ON * . * TO 'root'@'localhost';</code></p>
  
  <p>from a remote server to localhost/phpmyadmin but getting ERROR 1045 (28000): <code>Access denied for user 'root'@'%' (using password: NO).</code> </p>
  
  <pre><code>mysql&gt; show grants;
  +----------------------------------+
  | Grants for root@%                |
  +----------------------------------+
  | GRANT USAGE ON *.* TO 'root'@'%' |
  +----------------------------------+
  </code></pre>
  
  <p>How can I resolve this problem? I have gone through a lot of suggestions over internet but can't actually figure out.</p>