Multiple DB users on MT Grid-Service

Published on Friday 12th October, 2007 (AEST)

I host a couple of websites, including this one, on Media Temple. Their hosting services are excellent, but one thing that's always bugged me was the inability to have multiple MySQL database users. It meant that all sites had to use a single, all-powerful account to access databases. So much for least privilege. Other hosting providers I had used in the past had allowed me to set up read-only accounts—which can significantly add to the security of a web application—and I really missed this feature when I moved to (mt).

Well, I mustn't have been the only one peeved by this, as they have now added this feature to MySQL SmartPool v.2. New database accounts have no-access by default, and can be assigned read-only or read-write access.

Media Temple, I'm now gripe-free :)

Have something to add? Simply send me an email. Comments deemed relevant and helpful to other readers will be added to this page.

© 2007-2010 Andy Dowling. XHTML & CSS.