Skip to main content
NetApp Knowledgebase

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

Views:
98
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'

 

CUSTOMER EXCLUSIVE CONTENT

Registered NetApp customers get unlimited access to our dynamic Knowledge Base.

New authoritative content is published and updated each day by our team of experts.

Current Customer or Partner?

Sign In for unlimited access

New to NetApp?

Learn more about our award-winning Support