How to Install Yellowfin into AWS RDS MySQL

If you have ever tried to install Yellowfin into a fresh MySQL server hosted on AWS (particularly RDS) you may have run into the following error:

Yellowfin requires the ability to create sequences in its configuration database. Unfortunately this requires SUPER privileges which are not enabled by default in AWS. In order to allow the installer to create these sequences we need to create a DB parameter group with the parameter 'log_bin_trust_function_creators' set to 1

  1. Create a DB parameter group.
  2. Modify the DB parameter group as follows: log_bin_trust_function_creators=1
  3. Choose Save Changes.
    Note: After you create or modify a DB parameter group, wait at least five minutes before creating your first DB instance that uses that DB parameter group.
  4. From the navigation pane, choose Databases.
  5. Choose the instance that you want to associate with the DB parameter group.
  6. Choose Actions and choose Modify.
  7. Select the parameter group that you want to associate with the DB instance.
  8. You may need to reboot the database for the configuration to take effect.

Is this article helpful?
0 0 0