show slave mysql

mysql> SELECT * FROM information_schema.PROCESSLIST AS p WHERE p.COMMAND = 'Binlog Dump';

UPDATE mysql.db SET Host='%' WHERE Host='localhost' AND User='username';
FLUSH PRIVILEGES;

mysql create user


CREATE USER 'db_user'@'%' IDENTIFIED BY 'db_password';
GRANT ALL PRIVILEGES ON db_name.* TO 'db_user'@'%';

grant all on db_name.* to 'db_user'@'localhost' identified by 'db_password';


Try to dump without single-transaction option with mysqldump


ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
mysqld --verbose --help | grep ^socket
socket /var/lib/mysql/mysql.sock


CREATE USER 'root'@'%' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%';


PURGE BINARY LOGS BEFORE DATE_SUB( NOW( ), INTERVAL 3 DAY)

PURGE BINARY LOGS BEFORE DATE(NOW()) + INTERVAL 0 SECOND - INTERVAL 3 DAY;


max_binlog_files = 10

show global variables like "%expire_logs_days%";
show global variables like "%binlog_expire_logs_seconds%";