1. Home
  2. Security Hardening
  3. CIS MySQL 5.7 Linux OS L2 V1.0.0
  4. Ensure ‘sql_mode’ Contains ‘NO_AUTO_CREATE_USER’ – config files not found

Ensure ‘sql_mode’ Contains ‘NO_AUTO_CREATE_USER’ – config files not found

Details

NO_AUTO_CREATE_USER is an option for sql_mode that prevents a GRANT statement from automatically creating a user when authentication information is not provided.

Solution

Perform the following actions to remediate this setting:
1. Open the MySQL configuration file (my.cnf)
2. Find the sql_mode setting in the [mysqld] area
3. Add the NO_AUTO_CREATE_USER to the sql_mode setting

Supportive Information

The following resource is also helpful.

This control applies to the following type of system Unix.

Source

Updated on July 16, 2022
Was this article helpful?

Related Articles