MySQL Forums
Forum List  »  Replication

Store username/password encrypted in master info repository
Posted by: Matthias Glößl
Date: November 14, 2017 04:07AM

hi,
when setting up replication i get the following warning when issuing change-master-to with username and password:
"1760: Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information."

so i issued the change-master-to without specifying username/password and started the slave with the user and password option, which is working fine until a restart of the slave-machine happens. then the slave isn't working anymore until i stop it (stop slave) and start it with user/password again.

since i don't want to enter user/password after every restart, is there a way storing username/password encrypted in the master info repository?

kind regards,
matthias

Options: ReplyQuote


Subject
Views
Written By
Posted
Store username/password encrypted in master info repository
4431
November 14, 2017 04:07AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.