Secure Connections to MySQL

F

Faster

New member
Mar 10, 2010
16
0
0
Hopefully this is the right section.

I have a few MYSQL servers running on a few different VPSs. How do you guys create secure connections to create new databases, update schemas, etc?

I guess I could dump phpmyadmin on there but I am not always sure that is the most secure.

Thanks





 


If you have SSH enabled on the VPSs (assuming they're *nix) you can SSH in to them and run the mysql client (mysql -u username -p). It can be a bit tough if you're doing tons and tons of work, but everything goes through SSH, so it's fairly secure.

There are also the MySQL GUI tools which give you the PHPMyAdmin look-and-feel, but in a desktop application. I don't know what the level of security on those are though.

Vad
 
Look at SQLyog for doing local SQL work. Love it and I'd never use anything else. PHPmyadmin sucks compared to this. They have a free and paid virgin :)
 
patrick24601 said:
They have a free and paid virgin :)
Click to expand...
:338:

On my dedi server, I block access to all the services I don't want people to access/hammer/DOS/hax, including MySQL with iptables. I port proxy 3306 with my SSH client (SecureCRT). Then you can point any local GUI apps at localhost:3306.
 
port proxy? So you can make your local 3306 really map to a remote 3306 and the local apps are none the wiser?
 
patrick24601 said:
Look at SQLyog for doing local SQL work. Love it and I'd never use anything else. PHPmyadmin sucks compared to this. They have a free and paid virgin :)
Click to expand...

SQLyog is a good tool, also check out Navicat for MySQL. Navicat also has a free lite edition also.
 
You must log in or register to reply here.
Top Bottom