| 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: | |
| 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 | |
[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?
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