Hi
Look at the sample database.
try this
============create.sql======================
# Change user and password to add privileges for different user.
# Note that user with no hostname given is equivalent to specifying
# "%" as the hostname.
GRANT ALL ON pool.* TO contact;
DROP DATABASE IF EXISTS contact;
CREATE DATABASE aardwolf;
===========================
use something like the line below should do the trick :-)
mysql -u root < create.sql
Also make sure you have deleted the anonymous users in the user data base
they cause alsorts of problems
Richard
----- Original Message -----
From: "Jeremy Morano" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: 25 September 2001 16:38
Subject: creating database
>
> Hi there,
>
> I'm having a hard time creating a databae.......
>
> My db name is pool and my mySql username is contact.....
>
> This is what I did.......
>
>
> GRANT ALL ON pool.* TO contact
>
> CREATE DATABASE pool;
>
>
> The result was access denied...
>
> What do I do?
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php