How to reset the password if you forgot the password for report manager on OneClick machine

Document ID : KB000012250
Last Modified Date : 14/02/2018
Show Technical Document Details
Question:

How to reset the password  if you forgot the password for report manager in OneClick 

Environment:
Windows platfrom
Answer:

open a terminal window or a dos prompt (windows = start -> Run -> cmd)

change to your $SPECROOT/mysql/bin directory

do a mysql -uroot -proot to connect to the mysql database system

do a use reporting; don't forget the ; at the end!

do a select aes_decrypt(BOPassword, 'spectrum') from registry; again don't forget the ; at the end!

 

If your field says NULL you do not have set a password therefor leave it blank.