diff options
| author | monty@mashka.mysql.fi <> | 2002-09-22 18:02:39 +0300 |
|---|---|---|
| committer | monty@mashka.mysql.fi <> | 2002-09-22 18:02:39 +0300 |
| commit | 9c123d0c0b8637a91a1af87e93cc0b2428f3e9a7 (patch) | |
| tree | 7f6749bdfc76c04b8808fc36f0afc50291749ae8 /scripts/mysql_fix_privilege_tables.sh | |
| parent | 378d977d28c4583db43511e94b5c128f71b3304a (diff) | |
| download | mariadb-git-9c123d0c0b8637a91a1af87e93cc0b2428f3e9a7.tar.gz | |
Don't give the anonymous user create temp table or lock tables privileges.
SET PASSWORD=... closed connection on error.
Diffstat (limited to 'scripts/mysql_fix_privilege_tables.sh')
| -rw-r--r-- | scripts/mysql_fix_privilege_tables.sh | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/scripts/mysql_fix_privilege_tables.sh b/scripts/mysql_fix_privilege_tables.sh index 74e00e2c75a..247e3399b8b 100644 --- a/scripts/mysql_fix_privilege_tables.sh +++ b/scripts/mysql_fix_privilege_tables.sh @@ -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 where user<>""; END_OF_DATA echo "" fi |