| Bug #1752 | names have mistaken case in mysql_fix_privilege_tables.sql | ||
|---|---|---|---|
| Submitted: | 4 Nov 2003 21:29 | Modified: | 12 Nov 2003 5:18 |
| Reporter: | Daniel Convissor | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server: Installing | Severity: | S3 (Non-critical) |
| Version: | 4.0.16 | OS: | n/a |
| Assigned to: | Alexander Keremidarski | CPU Architecture: | Any |
[5 Nov 2003 4:34]
Alexander Keremidarski
Thanks for pointing this to us.
[12 Nov 2003 5:18]
Sergei Golubchik
fixed in 4.0.17
Description: Some field names don't use the correct case. Below is a patch file to correct this. How to repeat: . Suggested fix: --- mysql_fix_privilege_tables.sql 2003-09-08 21:45:04.000000000 -0400 +++ mysql_fix_privilege_tables.sql 2003-11-05 00:02:14.359375000 -0500 @@ -122 +122 @@ -add Show_db_priv enum('N','Y') DEFAULT 'N' NOT NULL AFTER alter_priv, +add Show_db_priv enum('N','Y') DEFAULT 'N' NOT NULL AFTER Alter_priv, @@ -135 +135 @@ - update user set show_db_priv= select_priv, super_priv=process_priv, execute_priv=process_priv, create_tmp_table_priv='Y', Lock_tables_priv='Y', Repl_slave_priv=file_priv, Repl_client_priv=file_priv where user<>""; + update user set Show_db_priv= Select_priv, Super_priv=Process_priv, Execute_priv=Process_priv, Create_tmp_table_priv='Y', Lock_tables_priv='Y', Repl_slave_priv=File_priv, Repl_client_priv=File_priv where user<>"";