API Gateway: Column count of mysql.user is wrong / mysql.servers doesn't exist errors

Products

• CA API Gateway
• API SECURITY
• CA API Gateway Enterprise Service Manager (Layer 7)
• STARTER PACK-7
• CA Microgateway

Issue/Introduction

When attempting to reinitialize replication you may experience one or both of the errors below

Message: ERROR 1805 (HY000) at line 1: Column count of mysql.user is wrong. Expected 45, found 42. The table is probably corrupted

ERROR 1146 (42S02) at line 1: Table 'mysql.servers' doesn't exist

Environment

Release : 9.3

Component : API GTW 

Resolution

The below command can be run on each node. This can upgrade and check/repair the mysql schema for errors.

mysql_upgrade -u root -p --force