phpstudy v8 gets an error when opening the database, but phpstudy 2018 does not

Question

The website built by phpstudy v8, the website membership registration card is in the process of registration, but there is no problem with phpstudy 2018, please help.

Answer 1

After MySQL 5.7.5, only_full_group_by becomes one of the default options of sql_mode, which may cause some sql statements to fail.

In the configuration file my.ini, add sql_mode=, as follows:

Then 'Save', and finally 'Restart MySQL service' (as shown below) can solve the problem Such questions.