I'm trying to use mysqldump on a remote host. My local IP is 22.214.171.124, and the remote IP is 126.96.36.199 I run this command:
mysqldump --host=188.8.131.52 -u user test_db
This doesn't work as what I get back this error:
mysqldump: Got error: 1045: Access denied for user 'user'@'184.108.40.206' (using password: NO) when trying to connect
So instead of connecting to the remote server, mysqldump tries to connect to the localhost.
Also, I noticed that when I replace the remote IP with another one, it tries to connect to that one.
Any idea why this happens?