Suppose this scenario:
SpectroSERVER hostname: server1 (where the Archive Manager is running, which manages the ddmdb database)
BSI hostname: server2
If you try to connect from the server2 to the MySQL server, on server1, you should get this type of message:
C:\> telnet server1 3306
Host 'server2.ca.com' is not allowed to connect to this MySQL server
Connection to host lost.
You have to provide access to a remote machine/account to the MySQL server.
On server1 (SpectroSERVER machine)
a) Open a bash shell (bash -login)
b) Navigate to the $SPECROOT/mysql/bin directory
c) Run: ./mysql -uroot -proot (Windows)
or Run: ./mysql --defaults-file=../my-spectrum.cnf -uroot -proot (Linux/Solaris)
d) Run:
mysql> GRANT ALL PRIVILEGES ON ddmdb.* TO 'spectrum'@'server2.ca.com' IDENTIFIED BY 'spectrum';
Query OK, 0 rows affected (0.17 sec)
Where: spectrum is the account and spectrum is the password on the server2 machine you are logged in.
Now the connection via telnet is successful from server2:
C:\> telnet server1 3306
5.5.39-enterprise-commercial-advanced-log#}vY;Y0"V!☻ǧk8rZMO(v>m.9mysql_native_password