Bug #3967 fix_privilege_tables doesn't use the password

• Submitted: 2 Jun 2004 15:30
• Modified: 3 Jun 2004 0:12
• Reporter: Matthias Urlichs
• Status: Can't repeat
• Category: MySQL Server: Installing
• Severity: S2 (Serious)
• Version: 4.1
• OS: -
• CPU Architecture: Any

[2 Jun 2004 15:30] Matthias Urlichs

Description:
The fix_privileges script doesn't use the password I give to it as an argument.

How to repeat:
Look at scripts/mysql_fix_privilege_tables.sh. You find:

cmd="$bindir/mysql -f --user=$user --host=$host"
if test -z "$password" ; then
  cmd="$cmd --password=$password"
fi

This is obviously wrong.

Suggested fix:
Add a bang:

cmd="$bindir/mysql -f --user=$user --host=$host"
if test ! -z "$password" ; then
  cmd="$cmd --password=$password"
fi

[3 Jun 2004 0:12] Matthew Lord

I was unable to repeat the problem in 4.0.20(binary) or 4.1.2 (bk source).  
If you need to provide a password you should do so as:
./mysql_fix_privilege_tables *******

[3 Jun 2004 4:12] Matthias Urlichs

So try it with a root account that doesn't *have* a password...