Active IQ Unified Manager Update fails because of password setting

Cause

• Upgrade MySQL outside the AIQUM is not suported
• AIQUM 9.8P1 could not be installed due to the set authentication method of MySQL user root
• Authentication method caching_sha2_password is not supported

Solution

1.     Open cmd (run as administrator)
2.     C:\Windows\System32> cd "%MYSQL_HOME%\bin"
3.     C:\Program Files\MySQL Server 8.0\bin> mysql.exe -u root -p
4.     Enter password:  (type the MySQL root password)
5.     mysql> select Host,User,plugin,password_last_changed from mysql.user;
6.     mysql> ALTER USER root@localhost IDENTIFIED WITH mysql_native_password BY 'MySecurePassword';
7.     restart of the server

Additional Information

How to access MySQL within all Active IQ Unified Manager platforms

Internal Notes

If this is encountered, please update Active IQ Unified Manager Update fails because of password setting.