diff options
author | monty@mashka.mysql.fi <> | 2002-06-16 17:06:12 +0300 |
---|---|---|
committer | monty@mashka.mysql.fi <> | 2002-06-16 17:06:12 +0300 |
commit | fc52abc50fa8a70e2ca5454998edc4b04f5e2cf8 (patch) | |
tree | 5f06cb07df859c884eed35668ba450e5060ab52a /scripts | |
parent | 33a377c7169c96b4a5fd3d0edba3f976df2ff3ba (diff) | |
download | mariadb-git-fc52abc50fa8a70e2ca5454998edc4b04f5e2cf8.tar.gz |
Cleanup of checking of user resources
Added missing checking of no_keyread
Diffstat (limited to 'scripts')
-rw-r--r-- | scripts/mysql_fix_privilege_tables.sh | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/scripts/mysql_fix_privilege_tables.sh b/scripts/mysql_fix_privilege_tables.sh index ead0350093a..7fc18aa1e2f 100644 --- a/scripts/mysql_fix_privilege_tables.sh +++ b/scripts/mysql_fix_privilege_tables.sh @@ -151,7 +151,7 @@ add Create_tmp_table_priv enum('N','Y') DEFAULT 'N' NOT NULL AFTER Super_priv, add Lock_tables_priv enum('N','Y') DEFAULT 'N' NOT NULL AFTER Create_tmp_table_priv, add Execute_priv enum('N','Y') DEFAULT 'N' NOT NULL AFTER Lock_tables_priv, add Repl_slave_priv enum('N','Y') DEFAULT 'N' NOT NULL AFTER Execute_priv, -add Repl_client_priv enum('N','Y') DEFAULT 'N' NOT NULL AFTER Repl_slave_priv +add Repl_client_priv enum('N','Y') DEFAULT 'N' NOT NULL AFTER Repl_slave_priv; END_OF_DATA if test $? -eq "0" @@ -160,7 +160,7 @@ then echo "" echo "Updating new privileges in MySQL 4.0.2 from old ones" @bindir@/mysql --user=root --password="$root_password" --host="$host" mysql <<END_OF_DATA - 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 + 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; END_OF_DATA echo "" fi |