Description:
If the user running mysql_fix_privilege_tables happens
to have safe-updates in their option file, it adversely
affects the operation of the script. I've pasted a relevant
mail message below. The fix suggested by Serg appears
to allow key-less UPDATE statements to work, so perhaps
it should be added to the beginning of
mysql_fix_privilege_tables.sql...
Date: Mon, 26 Jul 2004 23:20:23 +0200
From: Sergei Golubchik <serg@mysql.com>
To: Paul DuBois <paul@mysql.com>
Cc: dev-public@mysql.com
Subject: Re: Problem with mysql_fix_privilege_tables
User-Agent: Mutt/1.5.1i
Hi!
On Jul 26, Paul DuBois wrote:
> Something we should warning people about in the manual, or is there
> a fix that can be made to mysql_fix_privilege_tables itself?
May be
SET SQL_SAFE_UPDATES=0
?
:)
> >Date: 26 Jul 2004 14:17:27 -0000
> >To: comments@mysql.com
> >Subject: [comment] Upgrading-grant-tables
> >From: James Denholm-Price <j.denholm-price@kingston.ac.uk>
> >
> >Beware of safe mode when running mysql_fix_privilege_tables . It gave
> >several error messages in my upgrade from 3.23.49 to 4.0.20 that
> >disappeared after restarting the server with safe-updates commented out in
> >/etc/my.cnf
Regards,
Sergei
--
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <serg@mysql.com>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/ www.mysql.com
How to repeat:
See above.
Suggested fix:
See above.
Description: If the user running mysql_fix_privilege_tables happens to have safe-updates in their option file, it adversely affects the operation of the script. I've pasted a relevant mail message below. The fix suggested by Serg appears to allow key-less UPDATE statements to work, so perhaps it should be added to the beginning of mysql_fix_privilege_tables.sql... Date: Mon, 26 Jul 2004 23:20:23 +0200 From: Sergei Golubchik <serg@mysql.com> To: Paul DuBois <paul@mysql.com> Cc: dev-public@mysql.com Subject: Re: Problem with mysql_fix_privilege_tables User-Agent: Mutt/1.5.1i Hi! On Jul 26, Paul DuBois wrote: > Something we should warning people about in the manual, or is there > a fix that can be made to mysql_fix_privilege_tables itself? May be SET SQL_SAFE_UPDATES=0 ? :) > >Date: 26 Jul 2004 14:17:27 -0000 > >To: comments@mysql.com > >Subject: [comment] Upgrading-grant-tables > >From: James Denholm-Price <j.denholm-price@kingston.ac.uk> > > > >Beware of safe mode when running mysql_fix_privilege_tables . It gave > >several error messages in my upgrade from 3.23.49 to 4.0.20 that > >disappeared after restarting the server with safe-updates commented out in > >/etc/my.cnf Regards, Sergei -- __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik <serg@mysql.com> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany <___/ www.mysql.com How to repeat: See above. Suggested fix: See above.