Authenticating to a DB with a key?

Lonnie Olson lists at kittypee.com
Mon Apr 8 09:51:51 MDT 2013


On Sun, Apr 7, 2013 at 10:38 PM, S. Dale Morrey <sdalemorrey at gmail.com> wrote:
> I'm still feeling a little paranoid and I'm wondering if there is any way
> to do a certificate based login (MySQL or PostGres are options here).
> Similar to how I use private certs instead of username password combos.
> This way if my public box is compromised I can just revoke the cert.

Yup, MySQL can do SSL connections.  Both just encryption, and cert
authentication.
http://dev.mysql.com/doc/refman/5.0/en/ssl-connections.html

It's a bit complicated to setup initially, but the docs aren't that bad.


More information about the PLUG mailing list