Dedicated MySQL server question

I have a web server with a LOT of customer installed MySQL apps and I'm trying to add a dedicated MySQL server and move MySQL off the main web server to free up memory and increase performance.

All these applications talk to localhost, at least I think they do, and I don't want to go hunt them all up and modify them to change the IP address. Not unless I have to anyhow.

What I'm hoping to do is create an SSH tunnel to pipe port 3306 to the new box. That way I don't have to change everything and hope I found it all. I've managed to do this with SMTP and the POP and IMAP ports before and it worked. But for some reason MySQL isn't working. Here's what I'm trying to run.

autossh -M 3337 -f -N -g -L 3306:localhost:3306 mysql.ctyme.com

So - what am I missing? Shouldn't this work?

Thanks in advance.

 

 

 

 

Top