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
• Status: Closed
• Category: MySQL Server: Installing
• Severity: S2 (Serious)
• Version: 4.0
• OS: 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