Koozali.org: home of the SME Server

resync mysql root password

guestHH

resync mysql root password
« on: August 06, 2002, 07:15:45 PM »
Hi,

I know there is a 'simple' command to get the mysql root password back in sync with ldap. But again I simply can't find it any more in the forums.

help please... ;-)

Thx,
guestHH

guestHH

Re: resync mysql root password
« Reply #1 on: August 06, 2002, 07:33:26 PM »
...... and if I try the search option in different ways I would get this thread:

http://forums.contribs.org/index.php?topic=3248.msg10958#msg10958

Regards,
guestHH

Jon Blakely

Re: resync mysql root password
« Reply #2 on: August 07, 2002, 05:33:30 AM »
RequestedDeletion,

This is what you are after

To sync the passwords once, perform the following steps as the root user:
Stop MySQL.
   # /etc/rc.d/init.d/mysqld stop

Sync the MySQL password from the LDAP password.
   # /etc/e-smith/events/actions/conf-mysql-password

Start MySQL.
   # /etc/rc.d/init.d/mysqld start

Jon

guestHH

Re: resync mysql root password
« Reply #3 on: August 07, 2002, 11:19:58 AM »
Thanks Jon,

That is _exactly_ what I was after.

Maybe a tip for Dan B. to include this in his Howto. It says all about _not_ to change the password, but nothing on how to fix the problem.

Regards,
guestHH

Dan Brown

Re: resync mysql root password
« Reply #4 on: August 08, 2002, 04:13:29 AM »
Good idea, RequestedDeletion.  Take a look at it now.