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'

RE: Books advice

2003-08-04 Thread Jeffery C. Baldwin
. Again.. all of this is just my $.02 and I am VERY new at all of this DB stuff Jeff +---+ | Jeffery C Baldwin | Computer Consultant II | | University of North Carolina - Chapel Hill | 213 Miller Hall | CB# 1105 | Chapel Hill, NC 27599 | | Phone

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