what is wrong is mysql user creation
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
Subject
Views
Written By
Posted
what is wrong is mysql user creation
3936
October 07, 2005 05:26AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.