MySQL master in slave account password forgot to view the way

Regardless of the way to implement MySQL master-slave synchronization method, as long as the MySQL slave by reading the master bin binary files to achieve synchronization method will leave the connection master in the slave information, If you accidentally forgot what the password was when the master-slave sync was given, we can see the settings by viewing the Master.info file information under the Slave Library folder.

[[email protected] mysqldata]# cat Master.info 18mysql-bin.000042# read the main library's bin file 68711192.168.168.253# the main library iptest_backup# Master-Slave synchronization of the account test_backup# master-Slave synchronization of the password 3306# connection to the main library port 60001800.0000

This article is from the "Technical essay" blog, please be sure to keep this source http://jim123.blog.51cto.com/4763600/1836784

MySQL master in slave account password forgot to view the way