This is definitely something needed even if you hope to never ever whip open phpMyAdmin or MySQLWorkbench.
I’m thinking about doing a blog post titled “Things You Can Do In The WordPress Database That You Probably Shouldn’t But Might Have To Someday” and it would include things like
* Change a password
* Change a username
* Change a user levelWould this interest you?