ERROR 1045 (28000): Access denied for user 'root'@'%'
<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>