Entry

How do I allow a user to create his/her own databases?

Feb 12th, 2008 04:23
dman, Narendra Jain, Mike Thomas, http://sturly.com

Firstly, the user has to have administrative rights to mysql.
Once this is confirmed, then you can issue the command:
create database 'mydb';
After this the person can create tables, and start processing:
create table mytab (column1 integer, column2 char(25));
select * from mytab;