Mysql not letting root sign in without specifying password

Products

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

Issue/Introduction

On our NEW API Gateways, we are unable to sign into the mysql database using the command "mysql". On our old Gateways we are able to and we are not sure why?

 

Environment

Release : 10.0

Component : API GATEWAY

Resolution

If you have changed the root password from the default.

And # mysql -u root -p 

Allows login when specifying the password at the prompt.

You will need to modify the file

/root/.my.cnf

To have your new password since this is behind the scenes used to authorize the user and automatically specify the password for root.