i am currently working on a site where users signing up for a new account require a new mysql database to be generated with their account. i was surprised to find out how difficult this is. having code create a table is fine but i have not yet found a host that will let you create a database with code (it requires privileges not given). many offer unlimited databases but db creation has to be done through a control panel which is useless for sites requiring automated database set-up for new users.
has anyone else had this problem and can offer advice or a solution? many thanks.
create database privileges
Moderator: General Moderators
- Christopher
- Site Administrator
- Posts: 13596
- Joined: Wed Aug 25, 2004 7:54 pm
- Location: New York, NY, US
Re: create database privileges
Maybe try a virtual server rather than a shared hosting plan? The you can install MySQL and have complete control over it.
(#10850)