SOURCES: mysql.init - fixed bullshit about changing password for mysql_sysa...

[Jan Rekorajski]

On Mon, 13 Oct 2008, Elan Ruusamäe wrote:

> On Monday 13 October 2008 01:50, baggins wrote:
> > Author: baggins                      Date: Sun Oct 12 22:50:46 2008 GMT
> > Module: SOURCES                       Tag: HEAD
> > ---- Log message:
> > - fixed bullshit about changing password for mysql_sysadmin
> ...
> > @@ -431,7 +431,7 @@
> >
> >  mysqladmin -u mysql -S $MYSQL_SOCKET password 'password'
> >  mysqladmin -h $hostname -u mysql -S $MYSQL_SOCKET password 'password'
> > -mysqladmin -u mysql_sysadmin -S $MYSQL_SOCKET password 'password'
> > +echo "set password=password('newpassword');" | mysql -u mysql_sysadmin -S
> > $MYSQL_SOCKET
> 
> what bullshit. more details please?

The bullshit:
mysqladmin -u mysql_sysadmin password 'password' 

The effect:
mysqladmin: Can't turn off logging; error: 'Access denied; you need the SUPER privilege for this operation'

It does not work for a LOOOOONG time.
And adding SUPER priv to this user is a no-no.

Janek
-- 
Jan Rekorajski            |  ALL SUSPECTS ARE GUILTY. PERIOD!
baggins<at>mimuw.edu.pl   |  OTHERWISE THEY WOULDN'T BE SUSPECTS, WOULD THEY?
BOFH, MANIAC              |                   -- TROOPS by Kevin Rubio