Grant Access to the EUM Server MySQL Database

The Synthetic Server installer modifies the EUM MySQL database schema and the Synthetic Server stores data in the EUM MySQL database. Thus, you will need to grant MySQL users from the machine hosting the Synthetic Server privilege to the EUM Server's MySQL database.

  1. Log on to the machine where the EUM MySQL database is located.
  2. Connect to the MySQL Server with the EUM Server database. For example, if you are using the default EUM MySQL database, do the following:
    1. Change to<installDir>/AppDynamics/EUM .
    2. Connect to the EUM MySQL database:
      mysql/bin/mysql -u root -h <eum_server_hostname> -S <eum_server_mysql_sock> -P <eum_server_mysql_port> -p
  3. From the MySQL monitor, grant privileges to the MySQL user root of the Synthetic Server machine. The installer will use the MySQL user root to update the EUM database schema. Be sure to replace <on-prem-synthetic_server_hostname> with the URL to your Synthetic Server.
    MySQL 8.x
    mysql> CREATE USER 'root'@'<on-prem_synthetic_server_hostname>' IDENTIFIED BY '<db-root-password>';
mysql> GRANT ALL PRIVILEGES ON eum_db.* TO 'root'@'<on-prem_synthetic_server_hostname>';
    MySQL 5.x
    mysql> GRANT ALL PRIVILEGES ON eum_db.* TO 'root'@'<on-prem_synthetic_server_hostname>' IDENTIFIED BY '<db-root-password>';
    Note: The MySQL root user from the Synthetic Server is not related to the Linux user account that is installing the Synthetic Server. For example, the Linux user account ubuntu can run the installer, but the installer will use the MySQL user root when connecting to the EUM Server MySQL database to update the database schema.
  4. You will also need to grant access to the MySQL user eum_user to write data to the EUM database (eum_db). Be sure to replace <on-prem-synthetic_server_hostname> with the URL to your Synthetic Server.
    MySQL 8.x
    mysql> CREATE USER 'eum_user'@'<on-prem-synthetic_server_hostname>' IDENTIFIED BY '<db_eum_user_password>';
mysql> GRANT ALL PRIVILEGES ON eum_db.* TO 'eum_user'@'<on-prem-synthetic_server_hostname>';
    MySQL 5.x
    mysql> GRANT ALL PRIVILEGES ON eum_db.* TO 'eum_user'@'<on-prem_synthetic_server_hostname>' IDENTIFIED BY '<db_eum_user_password>';
  5. Set the password for the MySQL user root. The password should be the same as the one specified by the db_root_pwd in the inputs.groovy file.
    MySQL 8.x
    mysql> ALTER USER 'root'@'<on-prem-synthetic_server_hostname>' IDENTIFIED WITH 'caching_sha2_password' BY '<db-root-password>';
    MySQL 5.x
    mysql> SET PASSWORD FOR 'root'@'<on-prem-synthetic_server_hostname>' = PASSWORD('<db-root-password>');
  6. Confirm that you have granted permission for eum_user and root:
    show grants for eum_user@<on-prem_synthetic_server_hostname>;
show grants for root@<on-prem_synthetic_server_hostname>;