On 4 Aug 2003 at 12:06, Jeffery C. Baldwin wrote:
> Anyone notice the problem? Even though I get no error.. the sampdb is
> not being greated.
When are you attempting to create it? All you've shown is a GRANT
statement, which creates *permissions* for the database (and works
even if the datab
2003 12:21 PM
To: Jeffery C. Baldwin
Subject: Re: Unable to ADD databases
Seems no problem at all. GRANT does not CREATE databases, it just
GRANT
privileges. If you need to create a new database, you should try:
create database mynewdatabase;
Sincerily,
Leonardo Rodrigues
"Jeffery C. Baldwin" wrote:
>
> Hello All -
>
> I'm just started the process of learning MySQL and databases in general.
> I just bought the book 'MySQL' written by Paul DuBois, who I gather is
> really active in this community.
>
> Anyhow.. Here's the problem that I'm having.
>
> mysql> GRANT
Hello All -
I'm just started the process of learning MySQL and databases in general.
I just bought the book 'MySQL' written by Paul DuBois, who I gather is
really active in this community.
Anyhow.. Here's the problem that I'm having.
mysql> GRANT ALL ON sampdb.* TO 'sampadm'@'localhost' IDEN