KB221677: "The MySQL server is running with the --read-only option so it cannot execute this statement" error message is received when configuring MicroStrategy Intelligence Server 9.x and newer to MySQL Community metadata

SYMPTOM
When configuring the Strategy Intelligence Server 9.x and newer to a Metadata the following error message is received:
 

Server Definition manipulations error: (Database error <>: Execute Query failed.
 Error type: Odbc error. Odbc operation attempted: SQLExecDirect. [HY000:1290: on SQLHANDLE] [Strategy][ODBC MySQL Wire Protocol driver][MySQL]The MySQL server is running with the 
--read-only option so it cannot execute this statement)

 
CAUSE
The database user configuring the Intelligence Server to the metadata is set to read only mode and cannot execute the necessary queries to the MySQL Community database. 
 
ACTION
The following privileges are required for interacting with the metadata:

• Create
• Select
• Insert
• Update
• Drop
• Delete

 
Add the necessary privileges to the database user performing the configuration. For further reading refer to the following Strategy Knowledge Base article:
 KB7549: What permissions are needed for the metadata and warehouse to use Strategy products - Strategy Community