Mysql拒绝远程访问， sql_mode=only_full_group_by的解决

MYSQL禁止远程访问解决：

mysql -u root -p
mysql>use mysql;
mysql>update user set host = '%' where user = 'root';
mysql>select host, user from user;
mysql>FLUSH PRIVILEGES //修改生效

MySQL错误-this is incompatible with sql_mode=only_full_group_by解决方案

低版本的严格执行"SQL92标准，需要将select 字段写入group by，或者使用ANY_VALUE (）函数

SELECT
    ANY_VALUE ( org_id ) as org_id,
    ANY_VALUE ( org_name ),
    ANY_VALUE (barcode_id) ,
    ANY_VALUE (is_stocked) ,
    ANY_VALUE(item_code),
    ANY_VALUE(item_name),
    ANY_VALUE(item_id),
    ANY_VALUE(source_bill),
    ANY_VALUE(source_id),
    ANY_VALUE(source_line_no),
    ANY_VALUE(batch_number),
    ANY_VALUE(base_unit),
    ANY_VALUE(qty),
    ANY_VALUE(box_code),
    ANY_VALUE(warehouse_name),
    ANY_VALUE(warehouse_code),
    ANY_VALUE(location_code),
    ANY_VALUE(location_name),
    ANY_VALUE(area_name),
    ANY_VALUE(area_code) 
FROM
    wm_stock_detail_view 
WHERE
    area_code != 'R' 
    AND area_code != 'CH' 
GROUP BY
    area_code