I'm in a bit of a bind here. I have a client that wants me to set up his website, but he runs the server w/ SSH and CentOS 6.2 as its OS.
Now, I'm trying to add the SQL server on MySQL Workbench for easy handling, but I can't connect to MySQL. The SSH connection works fine, and I get privileges with sudo, so to speak.
The server guy said (and I use PuTTY by the way ): Open a tunnel on port 3306 (source) to dest: 127.0.0.1:3306 which is the MySQL port.
I have the user as "root" and have tried with the password I use to log on to my local SQL (phpmyadmin) as root, and I've tried with no password.
He also mentioned that the MySQL server only responds to loopback.
After this I haven't gotten a hold of him, and have very limited time. If you have pointers / suggestions or help I'd be very glad.
After countless hours of failure, I noticed I had used the wrong username for the MySQL connection inside Workbench. I used the same as my SSH login, which was wrong in my case. I had to use my dedicated MySQL username (obviously).