Posted by shimmyshack on 05/11/07 17:16

On 11 May, 17:52, harvey <harvey....@blueyonzders.com> wrote:
> In article <pan.2007.05.11.16.45.46.763...@you.now>, anno...@you.now
> says...
>
> > On Fri, 11 May 2007 16:42:23 +0000, harvey wrote:
>
> > > How do I make PHP create a database for mysql please?
>
> > query = "create database fred;";
>
> Oh god is it really that simple - this must be my day
> for asking dumb questions.
>
> Thanks for not lauging at me... at least not in public !

remember though that it's considered good practise not to have php
use root, give php too many permissions and it will only be time
before your hard work comes back to haunt you, instead get use
to creating the db using the mysql command line (or some helpful gui)
and then immediately create a new user which has rights over this
database, and plug that into the php scripts that use that db,
limiting potential for disaster.

[Back to original message]