Managing users / Mysql 5.7.6

[expired user #9654]'s profile image [expired user #9654] posted 8 years ago in General Permalink

SHOW GRANTS does not output IDENTIFIED BY PASSWORD '*XXXXXXXX' since MySQL 5.7.6.

http://dev.mysql.com/doc/refman/5.7/en/show-grants.html "As of MySQL 5.7.6, SHOW GRANTS output does not include IDENTIFIED BY PASSWORD clauses. Use the SHOW CREATE USER statement instead. See Section 13.7.5.12, “SHOW CREATE USER Syntax”."

This affects user manager - when you click on a user it will be marked with an exclamation mark and show "Password" field empty. If you edit privileges and click save, the password will be removed.

Please login to leave a reply, or register at first.