creating mysql databases with php.

[miles_rich]

is there anyway to create a mysql database with php code??

I have been trying for ages to do this but always end up having to make the database in the command prompt, but then i can create the tables through php..

any ideas or code.

• Tony

[bladx]

Use phpMyAdmin

http://www.phpmyadmin.net/

[vitch2002]

You should have no problems using the create database mysql syntax. Check that the user you are logging into mysql as has the relevant permissions.

[Psyche]

Heh, mysql_query() all the way.

For creating a database:

 $query = "CREATE DATABASE mydatabase";
 mysql_query($query);

For creating a table:

 $query = "CREATE TABLE myTable (id int not null auto_increment primary key, blah text, bleh text);";
 mysql_query($query);