This is my cheat sheet if I have to look back for an answer for problems. You're welcome to add or comment the answer.
Saturday, October 17, 2009
How to add a regular user to become Site Administrator in moodle from backend
Go to mysql and select the right database. Then select the userid that your username is using in mdl_user Then update mdl_role_assignments set roleid and contextid = 1 where your userid = thenumber above