Bug #17144 Missing default values in user table complicate insert into user table
Submitted: 5 Feb 2006 21:31 Modified: 4 Oct 2008 18:34
Reporter: Lonnie Best Email Updates:
Status: Unsupported Impact on me:
Category:MySQL Server: Security: Privileges Severity:S4 (Feature request)
Version:4.0 and above OS:Any (*)
Assigned to: CPU Architecture:Any

[5 Feb 2006 21:31] Lonnie Best
The process of adding a user via a SQL statement (insert into user) has been complicated by the fact that the fields ssl_type, ssl_cipher, x509_issuer, x509_subject have no default values. 

Because of this, the insert statement must explicitly specify these field names and values, therefore making the insert statement unnecessarily long.

How to repeat:
use mysql;
insert into user (Host,User,Password) values('','testUser',password('testPW'));

Suggested fix:
I propose that (at the table design level) the defaults be set to that which is implemented by default with the create user command / Grant command.
[14 Feb 2006 18:38] Brian Aker
You should use GRANT and REVOKE.
[4 Oct 2008 18:34] Konstantin Osipov
Thank you for your interest in MySQL.
Direct manipulation with privilege tables is not supported. 
Their contents may change in future.