what is wrong is mysql user creation

[anurag vidyarthi]

Hi All,

I m new to mysql .
I hv installed MYSQL server version: 5.0.13-rc on my solaris 8 machine.

I hv reset my root password to '' .

Now when I m doing following to create a user with the name bugs, I m not able to see it after creating it . although I m not getting any error while creation.
Mysteps are :-


bash-2.03# mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 119 to server version: 5.0.13-rc
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> select user,host from user ;
ERROR 1046 (3D000): No database selected

mysql> use bugs;
database changed

mysql>GRANT ALL PRIVILEGES ON bugs.* TO bugs@localhost IDENTIFIED BY 'bugs' ;
Query OK, 0 rows affected (0.00 sec)

mysql> flush privileges ;
Query OK, 0 rows affected (0.00 sec)

mysql> select user,host from user ;
ERROR 1146 (42S02): Table 'bugs.user' doesn't exist


I do not know why it is not showing the bugs user or what is wrong in my way.

With Kind Regards
Anurag Vidyarthi