create database privileges

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
russ72g
Forum Newbie
Posts: 8
Joined: Tue Jan 13, 2009 2:55 am

create database privileges

Post by russ72g »

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.
User avatar
Christopher
Site Administrator
Posts: 13596
Joined: Wed Aug 25, 2004 7:54 pm
Location: New York, NY, US

Re: create database privileges

Post by Christopher »

Maybe try a virtual server rather than a shared hosting plan? The you can install MySQL and have complete control over it.
(#10850)
Post Reply