Solution to err1055 error in mysql

This article mainly introduces the mysql err1055 error solutions, the content of the article is carefully selected and edited by the author, with a certain pertinence, for everyone's reference significance is still relatively great, the following with the author to understand the mysql err1055 error solution bar.

Mysql err 1055 error

Solution: query sql_mode in mysql, get the parameters of sql_mode, remove the only_full_group_by, copy the remaining parameters, and then paste it into the my.cnf configuration file to restart the mysql service.

Method guidance:

1.mysql-uroot-p 'password'

2.mysql > select @ @ sql_mode

| | ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION |

My.cnf configuration files are generally located in the / etc/ directory under the vim / ect/my.cnf, copy above and remove the only_full_group_by into the my.cnf file. Service mysqld restart (redhat linux) can restart the mysql service

Sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

Above you will find that we have turned off the only_full_group_by function. As for whether the only_full_group_by is closed or open. I looked up an answer on the Internet. I hope it will help you. Is the only_full_group_by mode of mysql on or off?

After reading the above about mysql err1055 error solutions, many readers must have some understanding, if you need to get more industry knowledge and information, you can continue to follow our industry information column.