Skip to main content
NetApp Knowledge Base

WFA table creation fails with the error: "Access denied for user 'root'@'localhost'" in OnCommand WFA Server

Views:
283
Visibility:
Public
Votes:
0
Category:
oncommand-workflow-automation-wfa
Specialty:
om
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'

 

Sign in to view the entire content of this KB article.

New to NetApp?

Learn more about our award-winning Support

Scan to view the article on your device