Alexander,
> Have you tried to reproduce them?
Bug #1: GRANT USAGE doesn't seem to create a user:
mysql> GRANT USAGE ON *.* TO 'foo'@'foohost';
Query OK, 0 rows affected (0.26 sec)
mysql> SHOW GRANTS FOR 'foo'@'foohost';
Empty set (0.03 sec)
mysql> SELECT Host, User, Password FROM mysql.user WHERE User = 'foo';
+---------+------+----------+
| Host | User | Password |
+---------+------+----------+
| foohost | foo | |
+---------+------+----------+
1 row in set (0.04 sec)
Bug #2: SHOW GRANTS shows wrong GRANT statement:
mysql> GRANT USAGE ON `footable`.* TO 'foo'@'foohost' IDENTIFIED BY
'foobar'
-> WITH GRANT OPTION;
Query OK, 0 rows affected (0.03 sec)
mysql> SHOW GRANTS FOR 'foo'@'foohost';
+-----------------------------------------------------------------------
----
| Grants for foo@foohost
+-----------------------------------------------------------------------
----
| GRANT USAGE ON *.* TO 'foo'@'foohost' IDENTIFIED BY PASSWORD
'4655c05b05f1
| GRANT ON `footable`.* TO 'foo'@'foohost' WITH GRANT OPTION
+-----------------------------------------------------------------------
----
2 rows in set (0.00 sec)
Yes, I can confirm both bugs you encountered. My settings:
Server version: 4.0.7-gamma-max-nt-log
OS: Win2K SP2
Maybe worth mentioning, a database 'footable' doesn't exist on my
machine. Double-checking this, I found out it doesn't matter if a
database exists or not. Bug #2 happens with database 'test', too.
Regards,
--
Stefan Hinz <[EMAIL PROTECTED]>
Geschäftsführer / CEO iConnect GmbH <http://iConnect.de>
Heesestr. 6, 12169 Berlin (Germany)
Tel: +49 30 7970948-0 Fax: +49 30 7970948-3
----- Original Message -----
From: "Alexander M. Turek" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, January 08, 2003 4:39 PM
Subject: RE: MySQL 4.0.7-gamma: Bugs affecting the privilege system
> Hi Stefan,
>
> -----Original Message-----
> From: Stefan Hinz, iConnect (Berlin)
> >
> > Alexander,
> >
> > > - After having set up both machines completely, I installed
> > > the Win32 binary distribution of MySQL 4.0.7-gamma. Although
> > > I did not upgrade from an earlier version, the privileges
> > > tables still have the old structure without the new columns
> > > introduced with MySQL 4.0.2-beta!
> > > Furthermore, the script menioned in the documentation
> > > (mysql_fix_privilege_tables) is obiously not included in the
> > > distribution. Because of this, there is no way to use the new
> > > privilege system but fixing the tables manually...
> >
> > I encountered the same issue, and Miguel Solórzano from MySQL
> > AB replied that it was his fault, simply forgetting the new
> > privilege tables in the Win32 dist.
> >
> > mysql_fix_privilege_tables is nowhere to find, but a list
> > member who had pulled the 4.1 source found it in there and
> > sent it to me. I extracted the SQL statements, ran the
> > script, and now my 4.0.7 has all the new privileges. You'll
> > find it at the bottom of this mail.
> >
> > Maybe this can fix the other bugs you reported, too.
>
> Hi Stefan,
>
> It does not.
> I fixed the priv tables manually, but the other two bugs are still
> occuring.
> Have you tried to reproduce them?
> Thanks,
>
> Alexander
>
>
>
>
> ---------------------------------------------------------------------
> 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
>
---------------------------------------------------------------------
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
