Koozali.org: home of the SME Server

Legacy Forums => Experienced User Forum => Topic started by: pwalter on October 08, 2005, 03:51:00 AM

Title: SME 7.0b4 - resetting mysql password
Post by: pwalter on October 08, 2005, 03:51:00 AM
It *used* to be that when you screwed up mysql, you could reset the mysql password by running the event conf-mysql-password, but that event no longer exists in 7.0b4. Does anyone know how to reset the mysql password, now?
Title: Re: SME 7.0b4 - resetting mysql password
Post by: CharlieBrady on October 09, 2005, 01:03:56 AM
Quote from: "pwalter"
It *used* to be that when you screwed up mysql, you could reset the mysql password by running the event conf-mysql-password, but that event no longer exists in 7.0b4. Does anyone know how to reset the mysql password, now?


Why do you think you want to reset the mysql password? How did you screw up mysql? Remember to report any/all 7.0beta malfunctions via the bug tracker at smeserver.sourceforge.net.
Title: SME 7.0b4 - resetting mysql password
Post by: pwalter on October 09, 2005, 02:32:29 AM
Charlie,
it wasn't a malfunction in 7.0b4 - it was *totally* my screwup (I overwrote /var/lib/mysql from a previous test install of 7.0b4 onto a new install). Prior to my screwup, mysql was working fine. Now, 'root'@'localhost' will not authenticate.
Title: SME 7.0b4 - resetting mysql password
Post by: CharlieBrady on October 10, 2005, 12:44:43 AM
Quote from: "pwalter"
Charlie,
it wasn't a malfunction in 7.0b4 - it was *totally* my screwup (I overwrote /var/lib/mysql from a previous test install of 7.0b4 onto a new install). Prior to my screwup, mysql was working fine. Now, 'root'@'localhost' will not authenticate.


You should be able to fix it by doing:

runsvctrl d /service/mysqld
rm -rf /var/lib/mysql/*
mv /home/e-smith/db/mysql/mysql.dump ~/mysql.dump.old
signal-event post-upgrade
signal-event reboot

Everything should be set up correctly, from scratch, as the system restarts.
Title: SME 7.0b4 - resetting mysql password
Post by: pwalter on October 10, 2005, 12:53:54 AM
Charlie,

Thank you very much.