Bug #76178 Default values of ssl_cipher x509_issuer x509_subject NULL but field NOT NULL
Submitted: 5 Mar 2015 16:02 Modified: 8 Apr 2015 12:12
Reporter: Wolfgang Gassler Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Security: Privileges Severity:S4 (Feature request)
Version:5.7.5-m15-log OS:Linux (CentOS 2.6.32-431.29.2.el6.x86_64 #1 SMP)
Assigned to: CPU Architecture:Any

[5 Mar 2015 16:02] Wolfgang Gassler
Description:

mysql> describe mysql.user;
...
| ssl_type               | enum('','ANY','X509','SPECIFIED') | NO   |     |                       |       |
| ssl_cipher             | blob                              | NO   |     | NULL                  |       |
| x509_issuer            | blob                              | NO   |     | NULL                  |       |
| x509_subject           | blob                              | NO   |     | NULL                  |       |
...

default value of fields are NULL but field is defined as NOT NULL.

mysql> select version();
+---------------+
| version()     |
+---------------+
| 5.7.5-m15-log |
+---------------+

How to repeat:
mysql> INSERT INTO mysql.user (User,Host,Password) VALUES ('admin', '%', password('topsecret'));
ERROR 1364 (HY000): Field 'ssl_cipher' doesn't have a default value

Suggested fix:
default value set to '' as did by grant command
[8 Apr 2015 12:12] Erlend Dahl
Discussed with the developer, this is more of a feature request.
[31 Mar 2019 0:57] xu liu
i just noticed this problem, how is this more of a feature request?