Creating Databases ?

[Fredatuk]

I am writting a program that processes clients data.

I want to be able to set up a new db for them with the program

using CREATE DATABASE but am told that I can't do this ??

 

Apparanty I can use phpmyadmin and do it manually - this

is odd because phpmyadmun is wrtten in php - and my program will just

use the same commands that I wil write in the sql box of phpmyadmin !

 

Are yu sure that I can't do this ? Is there a way of working round it ?

 

don't really want to do t manually because I want cients to have an

automatic setup.

 

Any ideas ?

[TweezerMan]

Apparanty I can use phpmyadmin and do it manually - this

is odd because phpmyadmun is wrtten in php - and my program will just

use the same commands that I wil write in the sql box of phpmyadmin !

I don't have any useful advice here, but I thought I'd point out a couple of things:

 

1) phpMyAdmin is accessed through your CPanel login, and your script would not be.

 

2) On my CPanel, phpMyAdmin does not have permission to create databases. If I want to create a database, I have to use the "MySQL Databases" page in CPanel to do so (which is a part of CPanel and not phpMyAdmin). Within phpMyAdmin, I am shown to have "No privileges" under "Create new database".

 

I'm sure there is a good reason for doing this (I would suspect this is done to prevent possible abuse), but I really don't know.

[Fredatuk]

Can these permissions be changed ?

 

I am writting a program that processes clients data.

I want to be able to set up a new db for them with the program

using CREATE DATABASE but am told that I can't do this ??

 

Apparanty I can use phpmyadmin and do it manually - this

is odd because phpmyadmun is wrtten in php - and my program will just

use the same commands that I wil write in the sql box of phpmyadmin !

 

Are yu sure that I can't do this ?  Is there a way of working round it ?

 

don't really want to do t manually because I want cients to have an

automatic setup.

 

Any ideas ?

<{POST_SNAPBACK}>