Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
10.4(EOL)
-
None
Description
When a TLS option is defined for a user, SHOW CREATE USER and SHOW GRANTS shows CIPHER '' in addition to the defined option(s); but it only happens after FLUSH PRIVILEGES.
CREATE USER foo REQUIRE ISSUER 'bar'; |
SHOW GRANTS FOR foo; |
SHOW CREATE USER foo; |
FLUSH PRIVILEGES; |
SHOW GRANTS FOR foo; |
SHOW CREATE USER foo; |
 |
# Cleanup
|
DROP USER foo; |
|
10.4 e7924a8598 |
SHOW GRANTS FOR foo;
|
Grants for foo@%
|
GRANT USAGE ON *.* TO 'foo'@'%' REQUIRE ISSUER 'bar'
|
SHOW CREATE USER foo;
|
CREATE USER for foo@%
|
CREATE USER 'foo'@'%' REQUIRE ISSUER 'bar'
|
FLUSH PRIVILEGES;
|
SHOW GRANTS FOR foo;
|
Grants for foo@%
|
GRANT USAGE ON *.* TO 'foo'@'%' REQUIRE ISSUER 'bar' CIPHER ''
|
SHOW CREATE USER foo;
|
CREATE USER for foo@%
|
CREATE USER 'foo'@'%' REQUIRE ISSUER 'bar' CIPHER ''
|
DROP USER foo;
|