Layer 7 CA API Gateway: MySQL sign-in asking for password

Products

• CA API Gateway

Issue/Introduction

In some cases new Gateway deployments added to an existing cluster will have issues logging into MySQL from the root shell without being asked for a password

 

Environment

Release : All

Component : API GATEWAY

Resolution

When running mysql -u root -p it may ask for a password 

Modify the file /root/.my.cnf

[client]

user=root
password=your_actual_mysql_root_password