开发者社区 问答 正文

按照《部署 LAMP (CentOS 7.2)》里面的操作安装Mysql总是有问题

php和apche都好了,但是mysql的远程访问不了,phpmyadmin也新建不了数据库




SQL 查询:
SELECT
                s.SCHEMA_NAME,
                s.DEFAULT_COLLATION_NAME
                   FROM `information_schema`.SCHEMATA s
                    GROUP BY BINARY s.SCHEMA_NAME
                    ORDER BY BINARY `SCHEMA_NAME` ASC
MySQL 返回:
#1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'information_schema.s.SCHEMA_NAME' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

展开
收起
jamescr7 2018-01-10 16:16:59 2524 分享 版权
1 条回答
写回答
取消 提交回答
  • 旺旺:nectar2。
    版主回复:

    请问上边的错误信息,是phpmyadmin显示的吗?

    或许您也可以试试从ssh登录到控制台后,尝试用命令来创建数据库。
    2018-01-10 18:58:41
    赞同 展开评论