diff options
| author | joerg@mysql.com <> | 2005-11-23 11:24:52 +0100 |
|---|---|---|
| committer | joerg@mysql.com <> | 2005-11-23 11:24:52 +0100 |
| commit | 3a7d81258cb3ad8a3561d1043cd6145da60a680a (patch) | |
| tree | 56273aaf5e5c680126ba25987e7b7227c4d29e31 /scripts | |
| parent | f2f239b5eecd0d9317809c9c22b0a8c6e69e133c (diff) | |
| parent | 9b0bfb88581444d9438391955aef576267c8ea92 (diff) | |
| download | mariadb-git-3a7d81258cb3ad8a3561d1043cd6145da60a680a.tar.gz | |
Merge mysql.com:/M51/mysql-5.1 into mysql.com:/M51/clone-5.1
Diffstat (limited to 'scripts')
| -rw-r--r-- | scripts/mysql_fix_privilege_tables.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/scripts/mysql_fix_privilege_tables.sql b/scripts/mysql_fix_privilege_tables.sql index bc20e698376..f8f10438505 100644 --- a/scripts/mysql_fix_privilege_tables.sql +++ b/scripts/mysql_fix_privilege_tables.sql @@ -35,7 +35,7 @@ ALTER TABLE user add Grant_priv enum('N','Y') COLLATE utf8_general_ci NOT NULL,a ALTER TABLE host add Grant_priv enum('N','Y') NOT NULL,add References_priv enum('N','Y') COLLATE utf8_general_ci NOT NULL,add Index_priv enum('N','Y') COLLATE utf8_general_ci NOT NULL,add Alter_priv enum('N','Y') COLLATE utf8_general_ci NOT NULL; ALTER TABLE db add Grant_priv enum('N','Y') COLLATE utf8_general_ci NOT NULL,add References_priv enum('N','Y') COLLATE utf8_general_ci NOT NULL,add Index_priv enum('N','Y') COLLATE utf8_general_ci NOT NULL,add Alter_priv enum('N','Y') COLLATE utf8_general_ci NOT NULL; ---- Fix privileges for old tables +-- Fix privileges for old tables UPDATE user SET Grant_priv=File_priv,References_priv=Create_priv,Index_priv=Create_priv,Alter_priv=Create_priv WHERE @hadGrantPriv = 0; UPDATE db SET References_priv=Create_priv,Index_priv=Create_priv,Alter_priv=Create_priv WHERE @hadGrantPriv = 0; UPDATE host SET References_priv=Create_priv,Index_priv=Create_priv,Alter_priv=Create_priv WHERE @hadGrantPriv = 0; |