Tagged Article: MySQL

How does Centos use scripts to regularly check the running status of MySql services? For example, the mysql service or php fpm service itself stops running from time to time or goes down for other reasons. Even if there is an email message notification, sometimes there is no computer or network around when you go out, and you can't manually restart these services at the moment, use scripts to time

Method 1: Use the SET PASSWORD command mysql -u root mysql> SET PASSWORD FOR ‘root’@’localhost’ = PASSWORD(‘newpass’); Method 2: Use m

#Vi/etc/my.cnf Find #/log bin=mysql bin binlog_format=mixed Comment # log bin=mysql bin # binlog_format=mixed Restart my