Hey,
I recently setup JIRA and MySQL on an Azure VM. I was unable to edit the MySQL config file as described in the installation documentation. There are couple of problems I faced.
1. Unable to edit my.ini file (MySQL service would not start after editing the file, not sure what was wrong)
2. Some of the configuration parameters are deprecated in my version of MySQL - innodb_large_prefix and innodb file format
3. Cannot set the innodb_log_file_size through the client
I have found a solution to problem one by setting these parameters through MySQL client using the following command:
set global character_set_server=utf8mb4
set global innodb_default_row_format= DYNAMIC
However, this needs to be done every time the DB instance does down. I have tried Altering the metadata as suggested in Atlassian Knowledge base. This will work only for character_set_server
Need help to resolve the other issues.
thank you in advance.
