MYSQL replication user password change

Products

• CA API Gateway

Issue/Introduction

After using "Alter user" mysql command to change the repluser password, the replication always has error "access denied for user 'repluser'"

Environment

Release : 10.0

Component : API GATEWAY

Resolution

Normally we should use add_slave_user.sh and create_slave.sh (don't need to copy database) to reset the password of replication user.

If use "Alter user" command to change the password, then we need to run following command to update the password for replication,

CHANGE MASTER TO MASTER_USER='repluser',MASTER_PASSWORD='<newpass>';