This is a very particular question, but I'm working on establishing a criteria at my company for when we bring new web clients aboard. Our sales team is looking for an effective way to determine whether or not we can install certain software on a client's web server before we sell the client on that service.
We help optimize a lot of our client's sites by installing blogs and CMSes to their existing site, but in order to install these blogs we need to be able to create MySQL databases through the client's hosting backend.
Of course many big name hosts like GoDaddy and Dreamhost give the user complete access to tools like phpMyAdmin that allow me to create a Wordpress database, for example, so that I can get Wordpress working on their site.
Many of our clients however are Ecommerce sites and get their hosting through more locked-down companies that don't offer the ability to utilize SQL databases or other features necessary to complete some of these tasks for clients.
It's an odd question, but is there a simple way to determine if a certain web server or hosting company has the ability to use SQL databases with their customers? Finding out the name of the hosting company and then checking if the company offers SQL databases would be one way to do it, but I want to know if there is another solution or web tool or chart on the internet that could help us determine this information.
CREATE DATABASE
command are completely irresponsible, in my opinion. MySQL's logging and record keeping isn't fine-grained enough to actually trace back ownership of a database to a particular user. Database creation is a responsibility that belongs entirely to the host, or their web hosting automation control panel software, if any, which can enforce naming rules and can be logged and restricted. – Charles May 18 '11 at 20:04