Re: Unable to ADD databases

2003-08-04 Thread Keith C. Ivey
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

RE: Unable to ADD databases

2003-08-04 Thread Jeffery C. Baldwin
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

Re: Unable to ADD databases

2003-08-04 Thread walt
"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

Unable to ADD databases

2003-08-04 Thread Jeffery C. Baldwin
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