AWWWW GEEZ! I apologize to all, I did not take the time to 'think' before I wrote.
Sorry for the waste of bandwidth :-) And thank you to Leonardo for the reply. Jeff -----Original Message----- From: Leonardo Rodrigues Magalhães [mailto:[EMAIL PROTECTED] Sent: Monday, August 04, 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 ----- Original Message ----- From: "Jeffery C. Baldwin" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, August 04, 2003 1:06 PM Subject: Unable to ADD databases > 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' IDENTIFIED BY > 'secret'; > Query OK, 0 rows affected (0.00 sec) > > mysql> show databases; > +----------+ > | Database | > +----------+ > | helpdesk | > | mysql | > | test | > +----------+ > 3 rows in set (0.01 sec) > > Anyone notice the problem? Even though I get no error.. the sampdb is > not being greated. This is weird as I've been able to use this exact > command in the past with no problems. I even tried logging in as root > before starting the mysql client, still made no difference. > > Thanks in advance.. > > Jeff > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
