title: MySQL Authentication failed to remote server
body: <pre><code>Authentication to host 'MY_DB_SERVER_IP_ADDRESS' for user 'root' using method 'mysql_native_password' failed with message: Access denied for user 'root'@'MY_APP_IP_ADDRESS' (using password: YES).
  </code></pre>
  
  <p>I have checked that I have full privileges for 'root'@'%'.</p>
  
  <p>why is this happening?</p>
  
  <p><strong>UPDATE:</strong>
  I can see that querying the db users shows on:</p>
  
  <pre><code>SHOW GRANTS FOR 'root'@'localhost'
  </code></pre>
  
  <p>it shows:</p>
  
  <ol>
  <li><p>'GRANT ALL PRIVILEGES ON <em>.</em> TO \'root\'@\'localhost\' IDENTIFIED BY PASSWORD \'*XXXXXXXXXXXXXXXXXXXXXX\' WITH GRANT OPTION'</p></li>
  <li><p>'GRANT PROXY ON \'\'@\'\' TO \'root\'@\'localhost\' WITH GRANT OPTION'</p></li>
  </ol>
  
  <p>when querying the db:</p>
  
  <pre><code>SHOW GRANTS FOR 'root'@'%'
  </code></pre>
  
  <p>it shows only:
  'GRANT ALL PRIVILEGES ON <em>.</em> TO \'root\'@\'%\' IDENTIFIED BY PASSWORD \'*XXXXXXXXXXXXXXXXXXXXXX\' WITH GRANT OPTION'</p>
  
  <p>Is this related to what I am asking?</p>