MYSQL replication user password change
search cancel

MYSQL replication user password change

book

Article ID: 232939

calendar_today

Updated On:

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>';