WFA table creation fails with the error: "Access denied for user 'root'@'localhost'" in OnCommand WFA Server
- Views:
- 389
- Visibility:
- Public
- Votes:
- 0
- Category:
- oncommand-workflow-automation-wfa
- Specialty:
- legacy
- Last Updated:
Applies to
OnCommand Workflow Automation(WFA) 4.2
Issue
MySQL table is not getting created when resetting the scheme in WFA.The following error will be logged in server.log.
2020-05-22 13:16:46,143 WARNING [org.mariadb.jdbc.internal.mysql.MySQLProtocol] (default task-73) Could not execute query GRANT ALL ON playground.* TO 'wfa'@'%' IDENTIFIED BY 'Wfa123': Access denied for user 'root'@'localhost' to database 'playground'
2020-05-22 13:16:46,143 ERROR [org.jboss.as.ejb3] (default task-73) javax.ejb.EJBTransactionRolledbackException: Failed to execute: GRANT ALL ON playground.* TO 'wfa'@'%' IDENTIFIED BY 'Wfa123'