'NO_AUTO_CREATE_USER error while installing drupal-7

When I trying to install drupal-7 in my server, at the setup database step it shows the error

Failed to connect to your database server. The server reports the following message: SQLSTATE[42000]: Syntax error or access violation: 1231 Variable 'sql_mode' can't be set to the value of 'NO_AUTO_CREATE_USER'.

The database name, username, and password are all correct.

Is there any solution to this problem?



Solution 1:[1]

Drupal isn't allowed to create a new user in your MySQL database. You need at least MySQL 5.0.15

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 user1704590