Navicat命令 【use库名；】 报错[err] 1055 处理方案记录

异常：在执行命令【use 库名;】时出现以下问题：

问题：[err] 1055 - expression #1 of order by clause is not in group by clause and contains nonaggregated column ‘information_schema.profiling.seq’ which is not functionally dependent on columns in group by clause; this is incompatible with sql_mode=only_full_group_by

分析：

根据异常信息分析能发现，这个问题主要是由于sql_mode引起，所以先查看sql_mode后修改即可，主要是去除only_full_group_by

解决方案：修改当前数据库的SQL_MODE

输入:
show variables like “sql_mode”;
set sql_mode=’’;
set sql_mode=‘no_engine_substitution,strict_trans_tables’;