We had this same problem on our site yesterday. We're running MySQL on Windows 2003.
There is a tracker bug posted, http://tracker.moodle.org/browse/MDL-10090 but nothing from the Moodle team yet.
Roles and permissions
Urgent help needed : Query failed in load_user_capability.
This discussion has been locked so you can no longer reply to it.