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