Re: Fwd: Re: bk commit - 4.0 tree [REQUIRE bug]

"How-To-Repeat:"


Forgot to send this to bugs...

>Date: Thu, 5 Sep 2002 12:41:21 -0500
>To: monty@mysql.com, dev-public@mysql.com
>From: Paul DuBois
>Subject: Re: bk commit - 4.0 tree
>
>At 16:17 +0300 9/5/02, monty@mysql.com wrote:
>>ChangeSet
>> 1.1293 02/09/05 16:17:08 monty@mashka.mysql.fi +33 -0
>> Fixed searching after ssl directories.
>
>Just want to confirm that this does indeed now work properly under
>Mac OS X.
>
>Also, I don't get the ssl_class.cc "won't-compile" problem under
>Mac OS X anymore. Thanks.
>
>> Fixed that GRANT ... REQUIRE options are not forgot when doing new GRANT
>
>Sorry, this still doesn't seem to work:
>
>mysql> grant all on *.* to y@localhost require ssl;
>Query OK, 0 rows affected (0.02 sec)
>
>mysql> select user,password,ssl_type from user where user='y';
>+------+----------+----------+
>| user | password | ssl_type |
>+------+----------+----------+
>| y | | ANY |
>+------+----------+----------+
>1 row in set (0.00 sec)
>
>mysql> grant all on *.* to y@localhost identified by 'z';
>Query OK, 0 rows affected (0.00 sec)
>
>mysql> select user,password,ssl_type from user where user='y';
>+------+------------------+----------+
>| user | password | ssl_type |
>+------+------------------+----------+
>| y | 606706ad6665ce1e | |
>+------+------------------+----------+
>1 row in set (0.00 sec)
>
>ssl_type has gotten trashed by the second GRANT.
>
>(I tried it a second time with grant usage rather than grant all for the
>second grant statement, and the same thing happens.)

------------------------------------------------------------ ---------
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 bugs-thread12520@lists.mysql.com
To unsubscribe, e-mail