Change Moodle user permission

Question

How to change the permission of an ordinary user to an administrator user in Moodle3.3 via SQL commands.

Answer 1

The site administrator function is allowed to do anything in Moodle, so use with caution.

You’ll need to know the user ID first - so recover the table id

SELECT *
FROM mdl_user
Then add the id to the value column here

SELECT *
FROM mdl_config
WHERE name = 'siteadmins'
For example

UPDATE mdl_config
SET value = value || ',3'
WHERE name = 'siteadmins'

You’ll probably need to go out and come back again so it can affect.

This only works for site administrators. For other functions, you need to log in as administrator and go to admin site -> users -> Permissions