MySQL agent collection is failing - error: "Incorrect database name ..."
说明
MySQL agent collection is failing with the below error message:
ERROR [Quartz[0]-10833] com.sma.mysql.agent.GenericSimpleTask - An unexpected error occurred which may cause undesired behavior. You may want to contact customer support if you see this error again: Error while performing collection for Databases
java.sql.SQLSyntaxErrorException: Incorrect database name '#mysql50#MyDB.MyCompany.com'
原因
Forbidden character in database name: "."
解决办法
The dot - "." - is a forbidden character for database name in older MySQL versions.
Please rename the database or remove it (if possible).