NAS probe NiS bridge fails to initialize database error encountered for MySQL backend database

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

After a new installation, the nas probe GUI was taking a very long time to load.  Setting the log level to 5 in raw configure and checking the logs, the below is observed:

nas: [last error] thread_id: 49621, error: mysql_real_connect: Access denied for user '<username>'@'xxx.xxx.xxx.xxx' (using password: YES) (errno:1045) 

nas: NiS bridge: Failed to initialize database. 

Environment

Release : 9.0.2
mysql 5.7.29

Component : UIM NAS

Cause

Database user was created with a '=' symbol in the password.  This special character isn't supported.  After changing the password and removing this character, the issue was resolved.

Resolution

We found that the root cause was an '=' sign in the mysql user password.  After getting this changed out, we were able to get everything running.