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

[Elan Ruusamäe]

On Monday 13 October 2008 12:31:51 Jan Rekorajski wrote:
> 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'
this is pointless too, as it's the same user, irregardless of the host?

> > > -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.

ou, it should be 'mysql' user, not 'mysql_sysadmin'!
but the syntax is still valid.

$ mysqladmin -u mysql password 'password' # sets password for 'mysql' user...

as mysql_sysadmin is just for rotating logs...

> Janek

-- 
glen