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