I created a user
'vasya'@'%' with all priveleges on some dbs on a remote server.
When I ssh to the server I can
mysql -u vasya -p without any problems.
However when I try to ssh tunnel via Sequel Pro using
host: 127.0.0.1 username: vasya password: ***** port: 3306 ssh host: <My Server IP> ssh user: <my server user that I used in terminal> ssh password: ***********
Unable to connect to host 127.0.0.1 because access was denied.
Double-check your username and password and ensure that access from your current location is permitted.
MySQL said: Access denied for user 'vasya'@'localhost' (using password: YES)
In my.cnf I have set this, even though I don't think it should be necessary for ssh tunneling:
#skip-networking bind-address = 0.0.0.0
Oh yes, I can successfully connect with Sequel Pro using another user I've created a while back that is no different then vasya.
What could be my problem with Vasya?