I can ssh onto the remote server and login without a problem.
I'm trying to connect to a remote mysql db over a ssh tunnel and running into issues. I've created the tunnel successfully (verified by telnet). When I try to login with the command:
mysql --host=127.0.0.1 -P 3302 -u fakeuser -p
Access denied for user 'fakeuser'@'192.168.100.93'
The issue is the @192.168.100.93. I believe I need that to be fakeuser@localhost. Since I'm connected through the SSH tunnel why isn't it being set to localhost? How do I force it to localhost? where is it getting the 192.168.100.93 from?
Note that I can't change any settings on the MySQL server.
Thanks for the help!