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

book

Article ID: 144459

calendar_today

Updated On:

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