To reset the MySQL root password, do the following:
USE DATABASE mysql;
SET PASSWORD FOR root@localhost=PASSWORD(‘yournewpassword’);
And voila! You have changed your password.
PS: If you have a “problem” with beeing able to login to MySQL without using password (even when it is set in MySQL), try to edit or delete ~/my.cnf, since that holds information used to avoid the login promt.
When RT is upgraded, users can experience WSOD(White Screen Of Death), all the log will say is:
“Out of memory! Callback called exit.”. Not so informative eh?
The solution is pretty simple, run this query in the database:
“ALTER TABLE sessions CHANGE a_session a_session LONGBLOB;”
Then clear the table with:
TRUNCATE TABLE `sessions`;
Any logged in users will be logged out, but the problem should disappear.