Answer for: What features do you want added to OnSite?
#22 Ability to access MySQL through a
client application
PHPMyAdmin is just awful, and my terminal skills just aren't up to par to avoid PHPMyAdmin. I'd love to be able to use a great client app such as Sequel Pro, but Modwest doesnt support MySQL clients.
3 votes
Comments |
Leave a comment
I know, I wish they could, but I don't think they should as it compromises the security we enjoy.
http://www.devshed.c...ity-Overview/
"When should you start to worry about MySQL security? When you start to use the MySQL server over an Internet connection. Why? Because that is when your MySQL server is going to be the most vulnerable to all kinds of attacks, such as alterations and denial of service."
There are a few customers that I know are successfully using ssh port forwarding to allow them to use a local SQL manager to securely connect to our mysql servers via shell.modwest.com.
http://modwest.com/help/kb6-188.html lists a couple of links in the contributed notes section. They may get you started.
I've used navicat successfully. You can either use the HTTP proxy, or use an SSH tunnel. When setting up the tunnel you may have to use the IP address rather than the host name to get a reliable connection. The tunnel seems more secure since you don't need to upload anything.