Mysqldump:Error:Binlogging on server not active

When learning to use mysqldump, the following two errors were encountered when using mysqldump backup:

[Email protected] backup]#./mysql_dump_back.sh

Warning:using a password on the command line interface can is insecure.

Mysqldump:Error:Binlogging on server not active

As shown above, one is because I configured in the mysql_dump_back.sh login database account password, mysqldump hint unsafe, another error, after searching for some information, only need to open log_bin inside the/ETC/MY.CNF ( Database operation log), and then restart MySQL to resolve the issue. There are a lot of this kind of information on the Internet, since the encounter is also recorded.

# Remove Leading # to turn on a very important data integrity option:logging

# Changes to the binary log between backups.

Log_bin=mysql-bin

Mysqldump:Error:Binlogging on server not active