PDA

View Full Version : create mysql



asherw
03-20-2009, 02:31 PM
I have used mysql wizard to create a database and phpadmin to manage a database.

Is it possible to create mysql database from scratch (wih php)? How do we assign access (users and passwords)?

Thanks in advance,
Asher

anonymous
03-21-2009, 07:27 PM
I suppose you can do it with php, but it'll be easier if you just use regular SQL.
Using your editor, you can type CREATE, ALLOW, DROP, GRANT, etc commands,
save the file and import the file from MySql Client.

Any reason why you'd want to use Php? You're thinking of releasing a cool app?

r2b2
03-22-2009, 02:54 PM
I don't believe you will have the required privileges to create databases outside of Cpanel.

The reason for this is that they need to control the database and user names being added to the MySql server as it is shared by all the users on your server...