phpstudy v8 gets an error when opening the database, but phpstudy 2018 does not
滴滴滴2021-02-28 12:55:20
0
1
1224
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.
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
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.