Bug #948 4.0 needs mysql_fix_privilege_tables.sql
Submitted: 29 Jul 2003 19:55 Modified: 10 Sep 2003 3:03
Reporter: Paul Dubois Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Installing Severity:S2 (Serious)
Version:4.0 OS:Microsoft Windows (Windows)
Assigned to: Bugs System CPU Architecture:Any

[29 Jul 2003 19:55] Paul Dubois
Description:
In MySQL 4.1, the inability of Windows users to be
able to update their grant tables has been solved
by extracting the SQL statements from the
mysql_fix_privilege_tables.sh script into the
mysql_fix_privilege_tables.sql file.

Unfortunately, the grant tables in 4.0 also
need to be updated, and Windows users have
no easy way to do so.

Please backport the 4.1 changes to 4.0.

Should proof be needed that this is a serious issue,
see the user comments for this page:

http://www.mysql.com/doc/en/Upgrading-from-3.23.html

How to repeat:
Upgrade to 4.0 on Windows.
Try to update the grant tables.
No easy way.

Suggested fix:
Same as was done for MySQL 4.1.
[27 Aug 2003 18:03] Greg Weir
This will be added as of 4.0.15.
[10 Sep 2003 3:03] Greg Weir
Now available in 4.0.15