Im in a bit of a bind here. I have a client that want's me to set up his website, but he runs the server w/ SSH and CentOS 6.2 as it's OS.
Now, I'm trying to add the sql server on Mysql Workbench for easy handling, but I cant 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 havent gotten a hold of him, and have very limited time. If you have pointers / suggestions or help I'd be very glad.
Edit: 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).
Thanks for the help, anyways!