Hi friends:
I try to grant privileges to a user named 'glen' but not succeed. Here is
the script:
-#####################################################################
mysql> update user set Password=password('tidbs1') where User='glen';
Query OK, 0 rows affected (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 0
mysql> select * from user where User='glen';
+-----------+------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+
| Host | User | Password | Select_priv | Insert_priv |
Update_priv
| Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv |
Process_priv | File_priv | Grant_priv | References_priv | Index_priv |
Alter_priv |
+-----------+------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+
| localhost | glen | 18c8ccb52a240cd8 | N | N | N
| N | N | N | N | N | N
| N | N | N | N | N |
+-----------+------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+
1 row in set (0.00 sec)
mysql> grant all privileges on test.* to 'glen'@'localhost' identified by
'tidbs1';
ERROR 1133: Can't find any matching row in the user table
mysql>
-###################################################################
Could you please tell me what the real meaning of the ERROR? The user an
doassword just remains in the user table? How come to say "Can't find any
matching row in the user table"?
Thank you very much for your help!
Duo
_________________________________________________________________
Chat with friends online, try MSN Messenger: http://messenger.msn.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <mysql-unsubscribe-##L=##[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
