"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 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
Jeff, You probably need to create the database first. "create database sampdb" then do the "grant all" walt -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
