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 _______________________________________________ pld-devel-en mailing list pld-devel-en@lists.pld-linux.org http://lists.pld-linux.org/mailman/listinfo/pld-devel-en