SQL注入

线上遇到同步中断,登录机器发现存在SQL注入导致

131108      1:02:59 [Note] Slave SQL thread initialized, starting replication in log 'mysql-bin.000521' at position 431027290, relay log './relay-bin.001616' position: 431027427
131108 1:02:59 [ERROR] Slave: Error 'Column 'email' cannot be null' on query. Default database: 'allvic'. Query: 'INSERT INTO 201108boc_user SET uid='',uname='njsncukd',mob='1',email='sample@email.tst'||(SELECT 'QjVm' FROM DUAL WHERE 6365=6365 AND ORD(MID((SELECT IFNULL(CAST(CHAR_LENGTH(schema_name) AS CHAR),0x20) FROM (SELECT DISTINCT(schema_name) FROM INFORMATION_SCHEMA.SCHEMATA LIMIT 3,1) AS mfop),1,1))>51 )||'',address='3137 Laguna Street',tim=now()', Error_code: 1048
131108  1:02:59 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'mysql-bin.000521' position 431027290

http://www.cnblogs.com/tanshuicai/archive/2010/02/03/1664900.html

原文地址:https://www.cnblogs.com/gsblog/p/3413845.html