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

I think not. Mysql distinguishes user by Host%User so the above may make
sense.

> > > > -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'!

No, the point of this command is to set password for user mysql_sysadmin.
First two mysqladmin commands set password for mysql.
If you run `mysqladmin -u mysql password 'password'` you will change password
for user mysql.

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