During the Platform Analytics installation and configuration, you are asked to create a MySQL database connection. To set up your MySQL database, you need to create a username and password to connect to MySQL.
When creating a password for the MySQL database, if the password contains a special character, such as $, !, .etc., the connection to the database cannot be established. The following error appears:
java.sql.SQLException: Access denied for user 'mstr@xxx' (using password: YES).
You are using a parameter on the command line that has a reserved character ($, !, .etc).
If your password includes certain special characters, you need to wrap the password in single-quotes. For example, 'password$inSingleQuotes'.
For more information on manually deploying the Platform Analytics repository, see the Platform Analytics help.
