mysql - phpmyadmin built on linux cannot build the database
我想大声告诉你
我想大声告诉你 2017-06-07 09:23:23
0
2
832

Linux After installing lamp on Alibaba Cloud, then installed phpmyadmin
System: Centos7.2

 apache
 mysql5.7.17
 php5.6
 

Then log in to phpmyadmin
I found an error when building the database
A colleague had the same problem.
Looking for a solution!

我想大声告诉你
我想大声告诉你

reply all(2)
巴扎黑

this is incompatible with sql_mode=only_full_group_by.

ONLY_FULL_GROUP_BY:

For GROUP BY aggregation operation, if the column in select does not appear in group by, then this SQL statement is illegal.

As a solution, add the following lines to my.cnf

[mysqld]
sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_pISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'

Remove only_full_group_by in sql_mode

Then restart MySQL Server.

曾经蜡笔没有小新

Look at the mysql error report saying that when selecting, there is no group by field in the select. Of course, this is just a low-level error. It may be that some configurations of your mysql or phpadmin are incorrect. Or the php extension required by phpadmin is not turned on.

Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template