Cannot create database: Access denied for user 'root'

Products

• CA API Gateway

Issue/Introduction

Seeing this error during installation/upgrade process:

Error:

code:28,000, AUTHORIZATION_FAILURE

Cause

Permissions not set due to a mistake during the the replication setup process. 

Environment

Release : 10.0

Component :

Resolution

Rerun through the entire replication setup process to ensure that the documentation is followed properly and the values entered are correct.