Unable to add MySQL PI to Azure MySQL agent (4226290)

When attempting to add PI (Performance Investigator) to the MySQL PI agent it fails on the following statement

/*************** - Create temp table for final output - ***************/

DROP TEMPORARY TABLE IF EXISTS prereq_master;

CREATE TEMPORARY TABLE prereq_master (

ParamName varchar(500),

ReqVal varchar(100),

ActVal varchar(100),

SqlCmd varchar (1000),

OptFile varchar (1000),

IsMandatory varchar(10));

with the following error:

java.sql.SQLSyntaxErrorException: Access denied for user 'sysadmin'@'%' to database 'mysql'

WORKAROUND

None

STATUS

Enhancement Request FGMYSQL-I-12 was logged to support MySQL on Azure.