I'm finally succeeded with ssh tunneling. My point is to open the mysql server to local users only (user@localhost etc.) while providing a remote control to my customers through ssh tunneling.
The problem is when I connect through the mysql command line tool (
mysql.exe -u root -h 127.0.0.1 --port=8600) I've got a
permission denied error for user email@example.com (the tunnel redirects from 127.0.0.1:8600 to my 3603 remote server)
Well it makes sense since my root exists in
mysql.user only with the
But then, is there a way for me to somehow tell mysql that this ip address is actually the server's address and that the root should be allowed to connect?
I've got no clue where to start. To me if such a thing existed it would be some kind of ip resolving table...