1.起首删除6行数据。
2.[root用户实行]
cd /home/mysql/binlog2sql-master/binlog2sql
python binlog2sql.py --flashback -uroot -p'Passw0rd*' -P3306 -dtestdb1 -ttest1 --start-file='mysql-bin.000001' --start-datetime='2025-02-28 15:00:00' > insert.sql
报错：
pymysql.err.OperationalError: (1045, u"Access denied for user 'root'@'127.0.0.1' (using password: YES)")
原因是没有'root'@'127.0.0.1'用户
3.[mysql用户实行]
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'127.0.0.1' WITH GRANT OPTION;
Query OK, 0 rows affected, 1 warning (0.00 sec)
mysql> ALTER USER 'root'@'127.0.0.1' IDENTIFIED BY 'Passw0rd*';
Query OK, 0 rows affected (0.00 sec)
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.01 sec)
mysql> source /home/mysql/binlog2sql-master/binlog2sql/insert.sql
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.01 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.01 sec)
Query OK, 1 row affected (0.00 sec)
mysql>
免责声明：如果侵犯了您的权益，请联系站长，我们会及时删除侵权内容，谢谢合作！更多信息从访问主页：qidao123.com:ToB企服之家，中国第一个企服评测及商务社交产业平台。 |
