在OnCommand WFA服务器中创建WFA表失败、并显示错误："access denied for user 'root'@ localhost"

最后更新
另存为PDF

Views:: 1

Visibility:: Public

Votes:: 0

Category:: oncommand-workflow-automation-wfa<a>WFA</a><a>MySQL</a><a>root</a><a>用于转换</a>

Specialty:: OM

Last Updated:

适用场景

OnCommand 工作流自动化(WFA) 4.2

问题描述

在WFA中重置方案时、未创建MySQL表。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'