|
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;
|
|