Re: "show grants for xyz" does no show all privileges

[Didier Wiroth]

Thanks Tobin for your contribution.

I presume you missed the lib (or isn't it required)?

I tried your method as a test for upgrading (to 5.5.30 and to 5.6.10), but the problem isn't solved. Show grants are still incomplete for existing accounts, it only shows the usage privileges.

I guess I have to do:
a) a fresh install
b) export every single db with mysqldump from old production db
c) import every single db (skipping the mysql schema) into new production db
d) recreate every single user in new production db
e) and recreate grants (on new production db) to have a clean production system and to have "show grants for xyz" to work as expected.

d.