ContributorKB article has incorrect(outdated?) command for apuser password change
Article link: https://support.sciencelogic.com/s/article/12015
While restoring a full backup our apuser passwords needed to be changed, as the password from a fresh reinstall and the password in our backup were different.
I followed the above KB articles instructions, and the below command from the article to change the password only came up with errors.
UPDATE user SET password=PASSWORD('new password') WHERE User='apuser';
I found article https://support.sciencelogic.com/s/article/1471 which talks about changing the MySQL User Account Passwords, and this below command seemed to work:
SET password FOR 'apuser' = PASSWORD("new password");
Perhaps the KB 12015 is aimed at a different SL1 version than ours, but it would be helpful if it had different options listed.
Our SL1 version is 12.1.1
Hello Joel,
Thank you for the details regarding the KB, I will forward to our Technical Support team for review and correction.
Customers can also use the thumbs up/down icon on the articles to send us feedback. Will be alerted to the feedback request and assign it out to the author to get updated and republished.
Rene'
