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 ALL ON

RE: Unable to ADD databases

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

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