| MySQL insert user error. mysql insert

| MySQL insert user error. mysql insert

When you add a user using insert, an error may be returned:

ERROR 1364 (HY000): Field 'ssl _ cipher 'doesn' t have a default value

The my-default.ini has a statement:

SQL _mode = NO_ENGINE_SUBSTITUTION, STRICT_TRANS_TABLES

Strict mode is specified. For the sake of security, strict mode prohibits you from directly modifying the user table in the mysql database in the form of insert to add new users.

Delete STRICT_TRANS_TABLES and use insert to add it.