| 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 | |
[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.
Description: 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('127.0.0.1','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.