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
>From: [EMAIL PROTECTED] (John R Levine)
>To: [EMAIL PROTECTED]
>Subject: MySQL 3.23 problems on BSDI 4.1
>Date: 15 Aug 2002 14:35:34 -0400
>
>I downloaded and built mysql-3.23.49 on my BSDI 4.1 system. It configured
>and built fine, but it hangs whenever I do more than the most trivial
>operations.
>
>It is my dim recollection that there have been problems with the thread
>libraries in the past. Does this ring a bell?
>
>(I can't use the prebuilt 4.2 binaries, because I'm not running 4.2 yet.)
>
>--
>John R. Levine, IECC, POB 727, Trumansburg NY 14886 +1 607 387 6869
>[EMAIL PROTECTED], Village Trustee and Sewer Commissioner,
>http://iecc.com/johnl,
>Member, Provisional board, Coalition Against Unsolicited Commercial E-mail
>
>---------------------------------------------------------------------
>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
><[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
_________________________________________________________________
MSN Photos is the easiest way to share and print your photos:
http://photos.msn.com/support/worldwide.aspx
---------------------------------------------------------------------
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
