Topic: SME 7.0b4 - resetting mysql password

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

[CharlieBrady]

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.

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

[CharlieBrady]

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.

[pwalter]

Charlie,

Thank you very much.