mysql - phpmyadmin built on linux cannot build the database

Question

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!

Answer 1

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.

Answer 2

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.