title: mysql not able to establish remote connection
body: <p>Could not able to connect to the remote mysql server using mysql workbench or direct command line.
  When trying it resolves different hostname </p>
  
  <p><a href="https://i.stack.imgur.com/Po0R2.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Po0R2.png" alt="Mysql workbench error message"></a></p>
  
  <p>When trying directly through command line </p>
  
  <pre><code>mysql --host=10.37.1.92 --port=3306 --user=root --password=password
  Warning: Using a password on the command line interface can be insecure.
  ERROR 1045 (28000): Access denied for user 'root'@'myaapvm.local' (using password: YES)
  </code></pre>
  
  <p>Tried, with password and without password, no luck.</p>
  
  <p>I tried to connect to 10.37.1.92 server but my mysql client try to connect to different server. The only way I can try now is directly login to the machine and do the change in my DB. I have disabled firewall in my mysql DB. Does anyone faced this issue please help.</p>
  
  <p>This server running  with maria DB installation.</p>